VLOOKUP from multiple sheets returns #N/A!
Hi,
I can't find why the VLOOKUP returns #N/A in column "R" of "Sheet1" in attached file;
I want to lookp up "C" column values from other sheets and return corresponding "L" column value from those sheets.
I've used this formula:
Could you please kindly guide me?
=VLOOKUP(C3;INDIRECT("'"&INDEX(SheetList;MATCH(1;--(COUNTIF(INDIRECT("'"&SheetList&"'!$B$4:$Z$1200");C3)>0);0))&"'!$B$4:$Z$1200");11;FALSE)
Last edited by omid020; 02-09-2017 at 05:42 AM.
Maybe:
=IFERROR(VLOOKUP(C3,INDIRECT("'"&SheetList&"'!$D$4:$AI$1150"),9,0)," not found")
Quang PT
Thank you bebo021999! but I'm confused why this formula does not work! :
=IFERROR(VLOOKUP(C3,INDIRECT("'"&SheetList&"'!$B$4:$AI$1150"),11,0)," not found")
This formula is seeking C3 value in B column of t1 sheet, check B column to see if it match?Originally Posted by omid020
Thank you bebo021999! but I'm confused why this formula does not work! :
=IFERROR(VLOOKUP(C3,INDIRECT("'"&SheetList&"'!$B$4:$AI$1150"),11,0)," not found")
Lookup data there is in "D" column but I want to lookup it from B to Z instead of D to Z of SheetList; While D is between B to Z why the formula which contains $B$4:$AI$1150 does not work!?
Testing indicates that the "Sheetlist" formula will not work if there is only one sheet.
I copied "t1" and renamed to "t2" , updated "Sheetlist" and the formula worked with the changes already outlined in previous postsi.e. change range
=VLOOKUP(C3;INDIRECT("'"&INDEX(SheetList;MATCH(1;--(COUNTIF(INDIRECT("'"&SheetList&"'!$D$4:$Z$1200");C3)>0);0))&"'!$D$4:$Z$1200");9;FALSE)
.. Because VLOOKUP requires the lookup parameter (C3) to the the FIRST parameter in the lookup range which is (has to be) D in this case.
Thank you John!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks