Match e-mail address with customer numbers

[tonnash]

Hi,

What I am trying to do is the following.

I have two separate workbooks:

In workbook no 1 I have all the customers' information. In this sheet the customer number sits in column B and email addresses sit in column O.
In workbook no 2 I am running a logbook, in which I need the customer's email address. In this workbook the customer number is also included, in column C. Now I have added column AI in which I want to search for email address that belongs to their customer number.

Which formula do I type in column AI in workbook no 2 to match email addresses with the customer number?

thank you so much!

[AliGW]

Try this:

=INDEX(columnO,match(C1,columnB,0))

[Glenn Kennedy]

if they are in separate workbooks, and the source workbook is closed, you'll need a bit more:

=INDEX('Filepath\[Workbookname.xlsx]Sheetname'!$O$1:$O$100,MATCH(C1,'Filepath\[Workbookname.xlsx]Sheetname'!$B$1:$B$100,0))