Forum Discussion
Solved
How to use MATCH in a VLOOKUP formula with INDIRECT
I have a workbook with multiple sheets for different communities, and I am trying to create a consolidated sheet with all items. I need to pull a date from a column within each sheet and insert it in...
A very small error in your formula
=VLOOKUP($B2,INDIRECT("'"&$A2&"'!$A$2:$k$20"),MATCH("Purchasing Final Phase PO Release",INDIRECT("'"&$A2&"'!$A$1:$K$1"),0),FALSE)
You might also consider removing the text from the MATCH function so it just refers to the column heading:
=VLOOKUP($B2,INDIRECT("'"&$A2&"'!$A$2:$k$20"),MATCH(E$1,INDIRECT("'"&$A2&"'!$A$1:$K$1"),0),FALSE)
A very small error in your formula
=VLOOKUP($B2,INDIRECT("'"&$A2&"'!$A$2:$k$20"),MATCH("Purchasing Final Phase PO Release",INDIRECT("'"&$A2&"'!$A$1:$K$1"),0),FALSE)
You might also consider removing the text from the MATCH function so it just refers to the column heading:
=VLOOKUP($B2,INDIRECT("'"&$A2&"'!$A$2:$k$20"),MATCH(E$1,INDIRECT("'"&$A2&"'!$A$1:$K$1"),0),FALSE)