Compare two columns input value from another
Solved/Closed
Related:
- Compare two columns input value from another
- How to input @ in laptop - Guide
- Lg tv change input name ✓ - Smart TV Forum
- Input phone password - Phones, PDA & GPS Forum
- Vlookup compare two columns ✓ - Excel Forum
- Input phone lock code sos - Phones, PDA & GPS Forum
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 28, 2010 at 06:45 PM
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