Good Afternoon All,
I've been trying to solve this formula problem. I am using serval vlookups across 3 different sheets in one workbook. The first part of the formula works and results in a blank cell. However, the 2nd part of the formula should display the date from one of the worksheets, but only displays False. I can't fiqure out how to fix it. Please see formula below. Thanks for your help.
=IF(ISNA(VLOOKUP(B8,Exported!E:F,2,0)),IF(ISNA(VLOOKUP(B8,'Exported 1'!F:G,2,0)),IF(ISNA(VLOOKUP(B8,'Exported 2'!F:G,2,0)),"",VLOOKUP(B8,Exported!E:F,2,0))))
Thanks Again!!!
Bookmarks