Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help on multiple criteria for formula and return a date
Hi all, I am new on your site and need help please. The formula should do the following;- Take Book 1, Sheet 1, A4 and B3, find them in Book 2 ,Sheet 1,A3 to A 1000, and B 3 to B 1000, and return the date in Book 2 sheet1, colomb C3.
A B C 1 Book 1 Sheet 1 2 Activity Code Activity Code 3 Coy number Q50012077-67 Q50012587-05 4 20017835 formula??? 5 20017870 6 20017916 7 20021864 8 9 10 A B C 1 Book 2 Sheet 1 2 Emp No Activity Code Start Date 3 20017703 Q50012077-67 2012/04/15 4 20017828 Q50012587-05 2012/04/10 5 20024161 Q50012365-11 2012/04/18 6 20024332 BECSA08407-01 2012/04/12 7 20020819 BECSA08407-01 2012/04/12 8 20020016 Q500123501 2012/04/20 Last edited by Vickaa : April 25th 12 at 03:15 PM Reason: I am trying to paste an example But ????? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on multiple criteria for formula and return a date
hi Vickaa,
it is an array formula to validate with ctrl + maj + enter =INDEX('[Book2.XLS]Sheet1'!$C1:$C500;EQUIV($A2&B$1;'[Book2.XLS]Sheet1'!$A1:$A500&'[Book2.XLS]Sheet1'!$B1:$B500;0)) -- isabelle Le 2012-04-25 10:14, Vickaa a écrit : Hi all, I am new on your site and need help please. The formula should do the following;- Take Book 1, Sheet 1, A4 and B3, find them in Book 2 ,Sheet 1,A3 to A 1000, and B 3 to B 1000, and return the date in Book 2 sheet1, colomb C3. A B C 1 Book 1 Sheet 1 2 Activity Code Activity Code 3 Coy number Q50012077-67 Q50012587-05 4 20017835 formula??? 5 20017870 6 20017916 7 20021864 8 9 10 A B C 1 Book 2 Sheet 1 2 Emp No Activity Code Start Date 3 20017703 Q50012077-67 2012/04/15 4 20017828 Q50012587-05 2012/04/10 5 20024161 Q50012365-11 2012/04/18 6 20024332 BECSA08407-01 2012/04/12 7 20020819 BECSA08407-01 2012/04/12 8 20020016 Q500123501 2012/04/20 |
#3
|
|||
|
|||
Many thanks Isabelle
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Index multiple criteria return multiple results | Excel Worksheet Functions | |||
formula for multiple criteria inc. date range | Excel Worksheet Functions | |||
How do I Return a Value Using Multiple Criteria? | Excel Discussion (Misc queries) | |||
Multiple Criteria Date Count formula | Excel Worksheet Functions | |||
return multiple records matching multiple criteria | Excel Worksheet Functions |