IF function with multiple possible returns

[olimajor123]

Hi there,

Looking for an IF formula for the following.

Column D shows the colour given to an area of a building, Blue, Green, Yellow, or Pink. Each colour has a different financial value - I am looking for Column E to show the financial value depending on the named colour in Column D.

Please can you help

Thanks

 

[Special-K99]

Try this in this order (first part has to be in alphabetical order,, e.g. Blue Green Pink Yellow)

=LOOKUP(A1,{"Blue","Green","Pink","Yellow"},{4,2,1,3})

 

[Chris Mack]

You could do this with a lookup table somewhere, and use VLOOKUP.

An IF formula would be:

=IF(D1="Blue",100,IF(D1="Green",200,IF(D1="Yellow",300,IF(D1="Pink",400))))

Hope this helps,

Chris.

 

[olimajor123]

Both worked.

Cheers guys

 

[Chris Mack]

Yw.