Comparing 2 columns from 2 different spreadsheets [Solved/Closed]

Report
-
 agauth -
Hello,
Here is what i am trying to do.
Spreadsheet 1 column B has customer numbers
Spreadsheet 2 column A also has customer numbers
Spreadsheet 2 column B has ID numbers

I am trying to write a function that will lookup spreadsheet2, and if it finds a customer number that exists in both sheets, write the ID number from spreadsheet2 in spreadsheet1 column C



1 reply

Posts
1923
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 29, 2021
143
agauth, Good evening.

Spreadsheet 1

C1 -->
=IFERROR(VLOOKUP(B1,Sheet2!$A$1:$B$100,2,FALSE),"NOT FOUND")

Please, tell us if it worked for you.
I hope it helps.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thank you so much, it worked. You are awesome.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!