Report

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

Ask a question agauth - Last answered on Jul 8, 2016 at 12:11 AM by 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



Helpful
+1
plus moins
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.
Was this answer helpful?  
agauth- Jul 8, 2016 at 12:11 AM
Thank you so much, it worked. You are awesome.

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!