ExcelBanter - Lookup...maybe

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Lookup...maybe (https://www.excelbanter.com/excel-programming/305259-lookup-maybe.html)

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 check both $A4 and $B4. Is it even possible?

Thanks in advance,

Robbyn

Sorry ..meant to post this in function group.

"Robbyn" wrote:

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 check both $A4 and $B4. Is it even possible?

Thanks in advance,

Robbyn