Forum Discussion

Reddyp's avatar
Reddyp
Helper I
4 years ago

look up based on one variable

"quanity" (sheet 1) where "Location" = USA (Sheet 2) = quantity (in new column) and when location dosent match, the result should be blank  Quantity Location Desired Result 10 USA 10 ...