MichaelWayne_71
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 60
I am doing a standard VLOOKUP across worksheets, but some of the "lookup values" & "table array" values are exactly the same with the size column (5) being the defining difference.
=VLOOKUP($A$2:$A$1608,POS_Inventory!$A$1:$E$9867,2,FALSE)
Any way to return value in column2 only if "lookup value" & columnE match?
thanks in advance
=VLOOKUP($A$2:$A$1608,POS_Inventory!$A$1:$E$9867,2,FALSE)
Any way to return value in column2 only if "lookup value" & columnE match?
thanks in advance