Steven,

The VLOOKUP returns a string, not a cell reference. INDIRECT that value to
get what you want

=CELL("contents",INDIRECT(VLOOKUP(D5,D8:E10,2,0)))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steven" wrote in message
...
I cannot get this function to work when using a VLookup.

My formula is =Cell("contents",VLOOKUP(D5,D8:E10,2,0))

where the VLookup returns an A1 or B1 or C1 etc. If I manually input the
formula =Cell("contents",A1) then it works fine. But when using the
vlookup
in the formula I get an error.

What is wrong?

Thanks for your help.

Steven