I have a formula that is as follows:
=VLOOKUP(B8,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,FALSE)
I am getting a result but also gettting a N/A result for which I want to use the following formula to resolve:
=IFERROR(VLOOKUP(B8],'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0),=IFERROR(VLOOKUP(B9,'[2019-10-30 BEST COST COMPLETE_20191026011813_963411.xlsx]BEST COST COMPLETE_'!$A$2:$O$50595,1,0)
NOTE that all I am doing is changing the lookup column from B8 to B9 however I am still getting an N/A result and I know that the information in B9 can be found.
Any suggestions on resolving this?
Bookmarks