I have a spreadsheet full of data about customers. Their email addresses in in column A sorted A-Z. This sheet is called CRM Data
On another sheet, I would like to enter their email address and have four fields fill in with a VLOOKUP. This sheet is called Example.
My formula is =VLOOKUP(F2,'CRM Data'!$A$2:$F$101,1).
F2 is where the email address is on the answer sheet.
CRM Data!$A$2:$F$101 is where we are looking. It is an absolute reference.
1 is the column number with the Contact ID which is the first thing I want to return on my answer sheet.
The VLOOKUP returns a value, but it is not the one that matches the email.
I have attached the spreadsheet.
Can you help me?