Matt Butcher
New Member
- Joined
- Jun 30, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi,
I have a workbook with two sheets. On the first sheet, called "Master", I have a lot of product data for items that we have sold, which includes a list of first names in column AH, surnames in column AI and a column AJ where I want to put in the contact person's email address.
On the second sheet, called "Email Lookup", I have an export of contact details from another database which I want to match to complete the email address field as above. This sheet contains six columns of data; column B has the surnames, column C has the first names and column F has the email address.
I have the following formula in "Master" sheet AJ2:
{=INDEX('Email Lookup'!$A$2:$F$8071,MATCH(1,('Email Lookup'!$B:$B=AI2)*('Email Lookup'!$C:$C=AH2),0),6)}
I have manually checked some entries against the lookup list and I know that I have matches.
All I get out is #N/A.
Thanks
I have a workbook with two sheets. On the first sheet, called "Master", I have a lot of product data for items that we have sold, which includes a list of first names in column AH, surnames in column AI and a column AJ where I want to put in the contact person's email address.
On the second sheet, called "Email Lookup", I have an export of contact details from another database which I want to match to complete the email address field as above. This sheet contains six columns of data; column B has the surnames, column C has the first names and column F has the email address.
I have the following formula in "Master" sheet AJ2:
{=INDEX('Email Lookup'!$A$2:$F$8071,MATCH(1,('Email Lookup'!$B:$B=AI2)*('Email Lookup'!$C:$C=AH2),0),6)}
I have manually checked some entries against the lookup list and I know that I have matches.
All I get out is #N/A.
Thanks