Lookup cell in another sheet (1 Viewer)

[captnk]

I need to look up a cell in another sheet using a row/cell reference in a different sheet.
Ok so in say Sheet2 Column AM,in row 1 I have "D5"
I need to look up cell D5 in Sheet1 (Sheet1!D5)
At the mom its looking up the cell reference AM1.
VLOOKUP(($AM1),Sheet1!$A$1:$BM$1000,3,FALSE)
How can I get it to look up the "Content of AM1 "D5" instead of the cell reference
CaptnK

 

[Sergeant]

I think you misunderstand the vLookup.
You can put =Sheet1!D5 in any cell in the workbook to grab the value from that cell.
You can also use =INDIRECT(AM1) but in AM1, you'd have to put Sheet1!D5.

 

[captnk]

Sergeant
Many Tks
Using "Indirect" works great
U just need to know the magic word
Captnk