I would like to use function to give car allowance for grade D on.

[Masoom Al-Omran]

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

 

[Gord Dibben]

Masoom

Just the one grade or multiples?

=LOOKUP(A1,{"A","B","C","D"},{"BD400","BD300","BD200","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

 

[Myo Ma Ma]

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

 

[Myo Ma Ma]

Find Car Allowance. Employees with grade D will get a Car Allowance BD 100 and others will get a zero.
Please Answer

 

[arnelgp]

here is your assignment.