Hi everybody,
can anyone help me with the attached ?
I'm looking for the correct formula to put in the aq column of the "result" sheet.
I guess an array formula is required but this is too difficult for me.
I need your help.
Many thanks in advance.
Best regards,
al
INTERIMAIRES.xlsx
My suggestion would be use an array vlookup. For your lookup table, if you move mission column to column E on the Base worksheet, and on the result worksheet AQ3, enter this formula with Ctrl + Shift + Enter keys together
=VLOOKUP(AM3,IF((BASE!$C$3:$C$5<AK3)*(BASE!$D$3:$D$5>AK3)*(BASE!$B$3:$B$5=AO3),BASE!$A$3:$E$5,""),5,0)
thank you very much JieJenn !
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks