=IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Big'!$B:$B,1,FALSE),"Project BIG",IF(VLOOKUP(D4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]Cran'!$B:$B,1,FALSE),"Project Cranberry",IF(VLOOKUP(AH4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]SMP BIG List'!$E:$E,1,FALSE),"Project BIG(Original)",IF(VLOOKUP(AH4,'[05.14_Wave 5 Priority 14 (Big+Cranberry) Specifications.xlsx]SMP BIG List'!$G:$G,1,FALSE),"Project BIG(New)"," "))))
Above is an excel code I am using to cross check SKUs on other sheets. If the VLOOKUP is found I want the [if_true_value] to state which sheet it's on (i.e. "Project BIG") if VLOOKUP is not found the [if_false_value] runs another VLOOKUP to search another sheet. The final [if_false_value] is " " which I simply wanted a blank cell if the SKU is not found. However I am getting #N/A is the cells.
So my question: Is this a valid way of using VLOOKUP? Is it actually iterating through the true/false conditions to the end of the code? And any suggestions to improve this?
Thanks for your time!