VLOOKUP and cell color problem.

  • Thread starter Thread starter lukus2005
  • Start date Start date
L

lukus2005

I have a spreadsheet to create a quotation/estimate and I use the
VLOOKUP function to retrieve the price of an item on another
worksheet. In that worksheet, I have several pricelists from various
suppliers but one column gives me the lowest price and changes the
cell color associated with the supplier so I know from which supplier
the price comes from.

Now my main quotation page displays the cheapest price but does not
pass along the cell color which I need so i can tell, by looking at
the quotation, which supplier i need to order each item from.

Is there a way to pass along not only the value of a cell but also its
color without using some VBA module.

TIA
 
Formulas return values--not formatting.

Can you use a helper column as an indicator, then use another =vlookup() to
return that indicator value?
 
Back
Top