Excel Formula

aacod

Well-known Member
Joined
Mar 20, 2009
Messages
667
I have a spreadsheet which has first and last names in columns B, E. H, L & O and phone #s in columns C, F, J, M and P.

I need formula in cell C4 such that when I type/fill in first and last name in cell B4, the formula brings the corresponding phone # to cell C4.

Thanks in advance.

aacod
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
First, create a true database where each line or record has all the information. And then use VLOOKUP

Having multiple columns of names and multiple columns for phone numbers means that you will have to do a nested if statement to check each set of names/Phone numbers until you get a return.

Jeff
 

GR00007

Board Regular
Joined
Apr 22, 2015
Messages
184
I'm just guessing from your relative cell positions, but would this work?
=if(b4=e4,f4,if(b4=h4,j4,if(b4=l4,m4,if(b4=o4,p4,"Not Found"))))
This will find the corresponding phone (F,J,M,P) of the corresponding name (E,H,L,O)
Name must match, Johnie Smith won't match John Smith
 

Watch MrExcel Video

Forum statistics

Threads
1,129,373
Messages
5,635,884
Members
416,886
Latest member
coreyalaurence37

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top