Forum Discussion
If/Or Formula Multiple Data
Hello, I have a data set as such, A B C unique email address 1 | 5 | unique email address 2 | 7 | unique email address 3 | 9 ...
Copy the email address that you want to look up into column C, starting in C1.
Enter the following formula in D1:
=XLOOKUP(C1,$A$1:$A$10000,$B$1:$B$10000,"")
This should work in Excel in Microsoft 365 or Office 2021. If you have an older version:
=IFERROR(VLOOKUP(C1,$A$1:$B$10000,2,FALSE),"")
If columns A/B contain more than 10000 rows of data, adjust the formula accordingly.
Fill down from D1.
HansVogelaar This did exactly what I needed it to do. Thank you very much. I greatly appreciate it.
Best,
Greg
