Posted to microsoft.public.excel.programming
|
|
Populate multiple cells off one equation
Thanks a million... this did exactly as I was hoping
"Stevie_mac" wrote:
Make a table of 3 columnsPartNo,
Cost,
Retail
Populate the Table
Select the full table & name it COST_TABLE
Put in CELL G1...
=VLOOKUP(A1,COST_TABLE,2,FALSE)
Put in CELL G1...
=VLOOKUP(A1,COST_TABLE,3,FALSE)
What it does...
When you change A1, VLOOKUP looks for the value of A1 in COST_TABLE then returns the matching item from COL2 or COL3 of
your table.
Hope it helps - Steve.
"Kevin Wallace" <Kevin wrote in message
...
I have created a drop-down list for parts in "A1". I need to populate the
cost price into "G1" and, the retail price into "J1" for whatever value is
chosen. I have created a list with the prices off to the side that I can
hide later. So I'm trying to create a formula that will populate the cells
at G1 and J1 based on the choice in A1. I have many part numbers and about
20 rows that I need to put the same formulas into.
If A1="X73495" then G1=O23 and J1=P23
If A1="C75639" then G1=O24 and J1=P24
If A1="P38427" then G1=O25 and J1=P25
|