help using LOOKUP

[ramsdesk]

I have master data like this.. (A1:B3)
A B
English 60
Maths 50
Science 75

Now there is huge data in detail. (D1:AA100). For one of the column I have check with the above master data. For eg:

If D1 is equal to (A1:A3), then check if E1 > (B1:B3) for corresponding A, if Yes then put "Y" in BB1.

So if D1 = Maths & if E1 = 60 then BB1 = 'Y'
if D2 = Science & if E2 = 50 then BB2 = 'N'.

Any pointers please...

Thanks,

[mangesh_yadav]

Use this in BB1
=IF(E1>=VLOOKUP(D1,$A$1:$B$3,2),"Y","N")

and copy down.

- Mangesh