IF with VLOOKUP Below I have represented a snippet of my 5000 rows of data. I ne

Question

IF with VLOOKUP

Below I have represented a snippet of my 5000 rows of data. I need to pull the Close Date (if there is one) from another workbook. In some case, there are rows of data but no values in Cols I/J/K so I've tried to reflect that here.

I need to populate any Close Dates from a separate workbook which only has Close Dates--branches that have not opened (Tampa) will not be listed in this 2nd workbook. If a branch has opened but not closed (Chicago) it will be listed in this 2nd workbook with a blank field in the Close Date column. I have represented here a sample:

I would like to return the Close Date where one is available, and a blank where a branch has neither closed nor opened. The closest I have come is:

=IF(I28>0,VLOOKUP(I28,'[Workbook name.xlsx]Sheet1'!$A:$B,2,FALSE)," "). This correctly brings back a valid Close Date for Sioux Falls and a blank for Tampa. However, Chicago shows as 1/0/1900.

Can you help me get a blank for Chicago or suggest another solution?

Thank you!

Column I Column J Column K Branch # Open Date Close Date 47 - Sioux Falls 03/14/2009 52 - Chicago 07/21/2010 36 - Tampa 47 - Sioux Falls 03/14/2009

Explanation / Answer

*Use below formula -=

=IF(I28>0,IFERROR(IF(VLOOKUP(I28,'[Workbook name.xlsx]Sheet1'!$A:$B,2,FALSE),VLOOKUP(I28,'[Workbook name.xlsx]Sheet1'!$A:$B,2,FALSE),""),""),"")

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---