G,
You could also select the search range, C4:F57, and name the range
(Insert / Name / Define). Call it something like "MyTable".
Then your formula would be:
=vlookup( "1A", MyTable, 4, False)
and you could copy it anywhere to maintain that reference.
Chris
|