View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason Lepack Jason Lepack is offline
external usenet poster
 
Posts: 120
Default Celll Address Lookup

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