Comparing 2 columns from 2 different spreadsheets
Solved/Closed
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
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
Related:
- Comparing 2 columns from 2 different spreadsheets
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Resident evil 2 remake free download - Download - Horror
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Jul 7, 2016 at 11:24 PM
Jul 7, 2016 at 11:24 PM
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.
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.
Jul 8, 2016 at 12:11 AM