Home > Forum Home > Automating Data Analysis Tasks > IF Statement > Combine IF statement with LOOKUP functions | Share |
Forum Topic | Login |
Combine If Statement With Lookup Functions | Rate this: (3/5 from 1 vote) |
You should first execute a VLOOKUP function on each of the columns using the option FALSE at the end to return only exact matches. An IF function can then be used to evaluate which column (if any) contains the date desired. The functions can be combined into one cell by embedding them; however it will be easier to first create the functions in separate cells and optionally join them at the end. | ||
Excel Business Forums Administrator | ||
Posted by Excel Helper on |
View Full Post |
Find relevant Excel templates and add-ins for Combine IF statement with LOOKUP functions in the Excel Business Solutions Directory |