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