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

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
 
M

Max

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
 
M

Max

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)
 
M

Max

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...
 
Top