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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,734
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,100,143
Messages
5,472,756
Members
406,836
Latest member
deeMD

This Week's Hot Topics

Top