List Lookup Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I've been trying to figure this out and searching through past posts, to no
avail.

Is there a way that if a certain person's name from a list of 200 poeple is
entered into A1, then B1 would return a text message like "Greater Florida"
and C1 would return a message like "MC"?

The returned data in B1 and C1 would be dependent upon the person's name
entered into A1.

Thank you
 
While you've given little information about how your list is laid out,
if it's something like:

J K L
1 Name1 Greater Florida MC
2 Name2 Lesser Delaware ZH
....

then one way:

B1: =IF(ISNA(MATCH(A1,J:J,FALSE)),"",VLOOKUP(A1,J:K,2,FALSE))
C1: =IF(B1="","",VLOOKUP(A1,J:L,3,FALSE))
 
Hey Bob,

I wasn't clear in my question.

Basically I am trying to keep a sheet 2 that has a list of 200 names or so.
If "John Doe" was entered into sheet 1 cell a1, then excel woudl return the
manager's name in b1 and job title in c1. All the data would be derived from
the list on sheet 2. But each person's name entered would deliver different
answers in b1 and c1.

Does that make sense?
 
Here are the details.

Sheet 3 will contain a list of 200 names in the A column. Each name will
carry a corresponding manager name and title in the b and c columns

For example:

A B C
Joe Dirt John Smith MCB


In sheet 1, if there is a match of the person's name in sheet three column
A, then sheet 1 would automatically fill in the B and C information in
columns B and C.

How would I do that?
 
Then you need a lookup

=IF(ISNA(VLOOKUP(A1,list_range,2,False)),"",VLOOKUP(A1,list_range,2,False))

and


=IF(ISNA(VLOOKUP(A1,list_range,3,False)),"",VLOOKUP(A1,list_range,3,False))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top