Celll Address Lookup

[Jason Lepack]

I have a list of cell addresses to be looked-up by their ids in column
A and B:

1,F1
2,M31
3,G6

etc.

now, what I want to do is create a lookup formula that will take the
integer result from a cell D3 and lookup the value in the cell that
corresponds with that integer.

I tried:
=cell("contents", vlookup(D3, A:B,2,false))

but that doesn't work because the vlookup returns a string.

All help will be greatly appreciated.

Thanks,
Jason

 

[Max]

Use INDIRECT, viz.: =INDIRECT(VLOOKUP(D3,A:B,2,FALSE))

 

[vezerid]

Jason,
you need one of the functions that return ranges, not values:

=CELL("contents",INDIRECT("B"&MATCH(D3,A:A,0)))

HTH
Kostis Vezerides

 

[Jason Lepack]

Use INDIRECT, viz.: =INDIRECT(VLOOKUP(D3,A:B,2,FALSE))
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---









- Show quoted text -

Awesome! Thanks very much!

 

[Max]

Welcome, Jason. Thanks for feeding back.