Is it possible to use a cell's address as the lookup_value in a Vlookup? For instance I need to know what is in $Z$1 in a different sheet. I would guess the vlookup would look something like =vlookup($Z$1, sheet 1, 2,false)
Has anyone ever done this?
Has anyone ever done this?