VLOOKUP and cell color problem.

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
 
D

Dave Peterson

Formulas return values--not formatting.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using vlookup to populate multiple rows at once 6
query too slow 1
help with lookup 3
query very slow 5
Formula to bring in the header 1
Checkboxes and Cell Color 3
Is there a way to parse multiple values in a cell and applycalculations on those values ? 0
Need running balance calc for packing list 0

Top