Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

View discussion in a popup

Replying to:
Reddyp
Helper I

get data where location criteria matches

"quanity" (sheet 1) where "Location" = USA (Sheet 2) = quantity (in new column)

and when location dosent match, the result should be blank 

QuantityLocationDesired Result
10USA10
30NZ 
22IND 
40USA40

Samarth_18
tamerj1