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))}
How to copy fill color with Lookup Formula?
Darthvazor wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
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?
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.