Daniel Valle
New Member
Database
SKUs Items Prices R
A B C D
A101 BLUE 200
A101 RED 200 R
A101 GREEN 200
B19 BLUE 300
B19 RED 300 R
B19 GREEN 300
D100 BLUE 50 R
D100 RED 50
F405 BLUE 5
F405 RED 5 R
F405 GREEN 5
G23 BLUE 30
G23 RED 30 R
G23 GREEN 30
Question:
What formula is needed to get
the item with this two variables
G23 and "R"
Result: RED
SKUs Items Prices R
A B C D
A101 BLUE 200
A101 RED 200 R
A101 GREEN 200
B19 BLUE 300
B19 RED 300 R
B19 GREEN 300
D100 BLUE 50 R
D100 RED 50
F405 BLUE 5
F405 RED 5 R
F405 GREEN 5
G23 BLUE 30
G23 RED 30 R
G23 GREEN 30
Question:
What formula is needed to get
the item with this two variables
G23 and "R"
Result: RED