Lookup

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

Guest

Accidentally posted this in programming, so reposting here.

Greetings,

The following formula (compliments to many fine folks in this forum) is used to copy info from Sheet 1A to Sheet 2:

=IF(ISNA(MATCH(D$3,'1A'!9:9,FALSE)),"",IF($A4="","",VLOOKUP($A4,'1A'!$A:$AH,MATCH(D$3,'1A'!9:9,FALSE),FALSE)))

Autofill is used across and down the worksheet.

$A4 contains the last name of a person. $B4 contains the first name. The problem is sometimes I have more than one person with the same last name, so I actually need the lookup to match both $A4 and $B4. Is it even possible?

Thanks in advance,

Robbyn
 
one way to do it would be to add a column c, where c4 = a4&b4, and d
the lookup on column c
 
Back
Top