formula ?

  • Thread starter Thread starter tom n.
  • Start date Start date
T

tom n.

I have a list set up with names on cell G7 the list of names run off of
H49:H349
I want the phone numbers of the names to run on cell G8 when the names is
picked on the list cell.
the phone numbers a on cel I49:I349
I tried all types of formulas and cant seem to get it.
 
Have you considered a VLOOKUP. Something like

=VLOOKUP(G7,$H$49:$I$349,2,FALSE)
 
Back
Top