formula within formula getting CELL/MATCH

Question

i am doing a vlookup of some value

is it possible to get the address of where that value was found?

are there any other ways besides match and cell?

i do thank you for your answers. but for some reason i am doing this:

=cell("address",VLOOKUP(B2,Component!A:F,6,FALSE))

and this is not working

i also tried:

=address(match(b2,Component!A:F,0))

and this did not work either

please help!

Answer 1

Hi,

Yes you can use the excel "Cell" function.

Something like the following:

Cell("address",VLOOKUP("your vlookup parameters"))

You can find additional information about the cell function here.

Enjoy!

Answer 2

try using this syntax

=ADDRESS(MATCH("what you are vlooking up",B1:B30,0),2)