I pulled them from your posting:

=IF(AL29=AI11,AJ11,"if(AL29=AI12, AJ12, """)

My assumptions:

so the name to look up is in AL29

the columns to look in are AI containing the list of names and AJ the pay
rate or whatever you are trying to return

the 2 says to return the value in the second column of the lookup range (AJ)
for the matching row.

the false means to find an exact match.

=vlookup(AL29,$AI$11:$AJ$200,2,False)

I assumed the names start in AI11 and run to AI200 (adjust for your actual
ranges).

All this is spelled out in help.

--
Regards,
Tom Ogilvy



"DangerMouse114 " wrote in
message ...
Im not sure where you pulled all those numbers from?! Can you give me an
explination of every new number?


---
Message posted from http://www.ExcelForum.com/