Log In
Register
Home
Active Member
January 27, 2018
Offline
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".
November 8, 2013
Online
Hi Mark,
Please upload a sample file with your data structure. It will not work with the formula you mentioned.
Active Member
January 27, 2018
Offline
Here it is. Thank you so much in advance!
November 8, 2013
Online
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.
Active Member
January 27, 2018
Offline
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
1 Guest(s)
