Use INDIRECT, viz.: =INDIRECT(VLOOKUP(D3,A:B,2,FALSE))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jason Lepack" wrote:
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