CODEWITHSUNDEEP
excelvlookup
ilikod
ilikod

Reputation: 1

Excel vlookup with address parameter

A cousin of mine asked me if i could help him with a function in Excel but i cant make it work. I have a function which is: 

=VLOOKUP(ADDRESS(ROW();COLUMN()+1;4);Sheet3!A2:B48;2)

the problem is that for the first parameter i am using the address function which works like an individual function but inside vlookup it returns the answer with quotation with result vlookup to stop working.

For example: if i run the function:

=ADDRESS(ROW();COLUMN()+1;4)

in A6 cell the result will be B6.

But inside the vlookup will return "B6".

Do you know any way to get the B6 answer inside the vlookup and not the"B6"?

Thanks!

Upvotes: 0

Views: 2457

Answers (1)

Scott Craner
Scott Craner

Reputation: 152585

Try using the INDIRECT() function:

=VLOOKUP(INDIRECT(ADDRESS(ROW();COLUMN()+1;4));Sheet3!A2:B48;2)

Upvotes: 2

Related Questions