Hello All,
I have tried the formula below and it worked perfectly:
=VLOOKUP(A4,INDIRECT("'"&INDEX(SheetList,MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A$1:$c$4"),A4)>0),0))&"'!$A$1:$c$4"),2,FALSE)
But what I am trying to figure out is, how to return value from a different row.
Like in the example formula given above, "lookup-value" is "A4", but i what i wanted to return-value is from "P22".
Hi Mark,
Please upload a sample file with your data structure. It will not work with the formula you mentioned.
Here it is. Thank you so much in advance!
Hi Mark,
The solution is simple:
If you put in cell D2 a simple reference to P22 (=P22), you will be able to use that formula. D2 is not used, and you can set the font to white, so it will not be visible.
Hello Everyone,
The previous solution works perfectly, and now I am trying to create a hyperlink to go directly to the vlookup value in the respective sheet.
But I am getting an error, can you help me please.
Thank you in advance.
=IFERROR(HYPERLINK(VLOOKUP(A17,INDIRECT("'"&INDEX(LinkEmpName,MATCH(1,--(COUNTIF(INDIRECT("'"&LinkEmpName&"'!$C$2:$P$22"),A17)>0),0))&"'!$C$2:$P$22"),11,FALSE),"View"),"Name Not Found")
Regards,
Markus
