View Single Post
  #7   Report Post  
Blue Hornet
 
Posts: n/a
Default

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