I have a worksheet in Excel there is a column titled Grade, and and another
column titled car allowance, I want to give the employee with grade D only BD
100, I tryed to use if function but I did not get the correct result.

Can you help me please...

Masoom

Just the one grade or multiples?

=LOOKUP(A1,{"A","B","C","D"},{"BD400","BD300","BD2 00","BD100"})

OR =VLOOKUP(A1,table,2,FALSE) where table is a range from columns B and C


Gord Dibben Excel MVP


On Mon, 23 May 2005 06:55:05 -0700, Masoom Al-Omran <Masoom
wrote:

I have a worksheet in Excel there is a column titled Grade, and and another
column titled car allowance, I want to give the employee with grade D only BD
100, I tryed to use if function but I did not get the correct result.

Can you help me please...