How do I create an "IF" within a drop box scenario

  • Thread starter Thread starter unco_dunco
  • Start date Start date
U

unco_dunco

=IF(OR(G8="POLO"),L8,"SELECT MODEL IDIOT")

I need the above sorted

I have a drop box with the words like so

POLO
GOLF
BORA

When I select Polo it generates and another cell (G5) the desire
result of $19990

How can it make the above formula to allow for multiple models. Fo
example if I now change the drop box to Golf I want the desired resul
of $25990 where the last result was displayed in G5.

I hope this was clearer than my last reques
 
Assume you have the data validation drop list in A1
to select either POLO, GOLF or BORA

and the price table below is in G8:H10

POLO $19,990
GOLF $25,990
BORA $20,990

Put in say, G8: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G8 will return the price of the car selected in A1
 
Typo corrections, apologies ..
Put in say, G8: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G8 will return the price of the car selected in A1
Click to expand...

should read as:
Put in say, G5: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G5 will return the price of the car selected in A1
Click to expand...

(The formula should be in a cell other than G8 - for e.g.: in G5 -
simply because the price table is already assumed to be in G8:H10)
 
Typo corrections, apologies ..
Put in say, G8: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G8 will return the price of the car selected in A1
Click to expand...

should read as:
Put in say, G5: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G5 will return the price of the car selected in A1
Click to expand...

(The formula should be in a cell other than G8 - for e.g.: in G5 -
simply because the price table is already assumed to be in G8:H10)
--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---
Max said:
Assume you have the data validation drop list in A1
to select either POLO, GOLF or BORA

and the price table below is in G8:H10

POLO $19,990
GOLF $25,990
BORA $20,990

Put in say, G8: =OFFSET($G$8,MATCH(A1,$G$8:$G$10,0)-1,1)

G8 will return the price of the car selected in A1
Click to expand...
 
Back
Top