|  

» Retrieving Sale Price Based On Item And Color Criteria

Problem:

Cells A1:C5 contain color and price data for a range of items.
We want to find the matching price for each pair of item and color values entered in A9:B11.

Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX($C$2:$C$5,MATCH(1,($A$2:$A$5=A9)*($B$2:$B$5=B9),0))}

Example:

Range1

Item________Color________Price
Sneakers____Red__________$70
Jeans_______Blue_________$50
T-Shirt_____Yellow_______#N/A


Range2

Item________Color______Price
Jeans_______Blue_______$50
Sneakers____Red________$70
T-Shirt_____Green______$10
Skirt_______Orange_____$30

Screenshot // Retrieving Sale Price Based On Item And Color Criteria
Retrieving Sale Price Based On Item And Color Criteria


Rate This Tip
12 34 5
Rating: 3.37     Views: 16557
How to copy fill color with Lookup Formula?
Darthvazor
I am trying to find a way how to use Lookup Formula to copy text and fill color to whever i put it in. When i used Lookup Formula and it only get text and didnt copy fill color to the cell i want it to be. Any help will be appericated. Thanks.

Darthvazor
Vlookup Color
joboozy
I am trying to Vlookup values and bring both the font color and the value into the cell. Does anyone know how to do this?
Click here to post comment
For Registered Users
Name
Comment Title
Comments