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

agauth - Jul 7, 2016 at 09:24 PM - Latest reply:  agauth
- Jul 8, 2016 at 12:11 AM
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

See more 

2 replies

Mazzaropi 1807 Posts Monday August 16, 2010Registration dateContributorStatus March 23, 2018 Last seen - Jul 7, 2016 at 11:24 PM
agauth, Good evening.

Spreadsheet 1

C1 -->

Please, tell us if it worked for you.
I hope it helps.
Was this answer helpful?  
Thank you so much, it worked. You are awesome.