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