Compare two columns input value from another
Solved/Closed
Related:
- Compare two columns input value from another
- Compare two columns in excel for partial matches - Guide
- Comparing two columns of names in Excel ✓ - Forum - Excel
- A variation on the compare 2 columns in Excel ✓ - Forum - Excel
- I would like to compare 2 columns. ✓ - Forum - Excel
- How to compare several columns...? ✓ - Forum - Excel
1 reply
rizvisa1
May 28, 2010 at 06:45 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
May 28, 2010 at 06:45 PM
You need to use VLOOKUP on inventory as
=IF(ISERROR(VLOOKUP(A2, customers!A:B,2,false)), "", VLOOKUP(A2, customers!A:B,2,false))
=IF(ISERROR(VLOOKUP(A2, customers!A:B,2,false)), "", VLOOKUP(A2, customers!A:B,2,false))
Jul 6, 2016 at 11:23 AM