Compare two columns input value from another
Solved/Closed
Related:
- Compare two columns input value from another
- How to input @ in laptop - Guide
- Display two columns in data validation list but return only one - Guide
- Lg tv change input name - Guide
- Tweetdeck larger columns - Guide
- Beyond compare - Download - File management
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