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 - 09 Feb 2007 14:07 GMT
Use INDIRECT, viz.: =INDIRECT(VLOOKUP(D3,A:B,2,FALSE))

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> I have a list of cell addresses to be looked-up by their ids in column
> A and B:
[quoted text clipped - 18 lines]
> Thanks,
> Jason
Jason Lepack - 09 Feb 2007 14:11 GMT
> Use INDIRECT, viz.: =INDIRECT(VLOOKUP(D3,A:B,2,FALSE))
> --
[quoted text clipped - 27 lines]
>
> - Show quoted text -
Awesome! Thanks very much!
Max - 09 Feb 2007 14:25 GMT
Welcome, Jason. Thanks for feeding back.

Signature
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> Awesome! Thanks very much!
vezerid - 09 Feb 2007 14:11 GMT
Jason,
you need one of the functions that return ranges, not values:
=CELL("contents",INDIRECT("B"&MATCH(D3,A:A,0)))
HTH
Kostis Vezerides
> I have a list of cell addresses to be looked-up by their ids in column
> A and B:
[quoted text clipped - 18 lines]
> Thanks,
> Jason