IF Function Problem

[prkhan56]

Hello All,

I am using Office XP and have the following problem

I have a worksheet which uses lookup to extract names from range name
Codes as follows

Col
O=IF(ISNA(VLOOKUP(D2,CODES,6,FALSE)),"",(VLOOKUP(D2,CODES,6,FALSE)))


I wish to add another IF condition to the above formula to test that:
If Col D2 = EGSP AND Col A = date greater than or equal to 15-Nov-2005
then it should display the name as 'Jack' otherwise 'James'.

All other values should remain unchanged

Thanks a lot

Rashid

 

[Bob Phillips]

=IF(D2="EGSP",IF(A2>=--"2005-11-15","Jack","James"),IF(ISNA(VLOOKUP(D2,CODES
,6,FALSE)),"",(VLOOKUP(D2,CODES,6,FALSE))))

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[prkhan56]

Hello Bob,
Sorry for the delay.. it works fine.. Thanks a lot

Rashid