Thread: Multiple If and Vlookup function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav Dav is offline
external usenet poster
  
Posts: 1
Default Multiple If and Vlookup function

Obviously you will have to put the proper cell references in but

If(and( Employee number (O) = Employee Number (D), Weekending Date (O)
= Weekending Date (D), Pay Item Description (O) = Pay Item Description
(D)), vlookup(Employee Number(C5),"Employee Details"!C1:K25,8,False),"
")

Unless you are performing a match down the whole column, Perhaps you
need to give more details of what you exactly want.

Regards Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=570651

Reply With QuoteReply With Quote