| Home > Forum Home > Automating Data Analysis Tasks > selective cells for use in a different spreadsheet > VLOOKUP and IF functions | Share |
VLOOKUP and IF functions
Excel Help for Vlookup And If Functions in Automating Data Analysis Tasks
| Forum Topic | Login |
Vlookup And If Functions | Rate this: (3/5 from 1 vote) |
 | This can be done with VBA code; however the spreadsheet may be simple enough to do this using formulas. If this is the case, it could be done with a combination of VLOOKUP and IF functions entered in the printable sheet. The VLOOKUP function can start to look up values from one of the sheets. The IF function can then be wrapped around this several times to encompass the other sheets. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for VLOOKUP and IF functions in the Excel Business Solutions Directory |