Home > Forum Home > Automating Data Analysis Tasks > IF Statement > Combine IF statement with LOOKUP functions Share

Combine IF statement with LOOKUP functions

Excel Help for Combine If Statement With Lookup Functions in Automating Data Analysis Tasks


Forum TopicLogin

Combine If Statement With Lookup Functions

Rate this:
(3/5 from 1 vote)
OopsYou 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 on
 
View Full Post

Find relevant Excel templates and add-ins for Combine IF statement with LOOKUP functions in the