Report

Comparing 2 columns from 2 different spreadsheets [Solved]

Ask a question agauth - Last answered on Jul 8, 2016 12:11AM
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
See more 
Helpful
+0
moins plus
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.
agauth- Jul 8, 2016 12:11AM
Thank you so much, it worked. You are awesome.
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!