Forum Discussion

Copper Contributor

Jun 01, 2022

Solved

VLookup nesting

Can you use a VLookup within a VLookup to fill the table_array value?

Copper Contributor

Jun 03, 2022

You are correct that I needed HLOOKUP and I had it in my original worksheet. However, when I try the string you provided, I get a #N/A error.

Silver Contributor

Jun 03, 2022

Betsy1915 sorry I had a small typo:

=HLOOKUP($A$11,INDIRECT(VLOOKUP($A$12,$A$1:$I$13,2,FALSE)),4,FALSE)

basically that internal VLOOKUP range should be $A$1:...

see attached