Have you considered a VLOOKUP. Something like

=VLOOKUP(G7,$H$49:$I$349,2,FALSE)
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"tom n." wrote:

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.