Hi,
I have:
<tbody>
</tbody>
C17 is like: Jan FY13, Feb FY13, Jun FY13, Apr FY13, May FY2014
In my source I have column with other format date (Sheet2, column B): DD-MMM-YYYY (31-May-2014 or 30-Apr-2014).
Now I want to use Match function to find owner.
How I need to write proper function to find owner??
I have:
Date | C17 = Jan FY13 |
Name | C20 = Audi |
Owner | E53 = |
<tbody>
</tbody>
C17 is like: Jan FY13, Feb FY13, Jun FY13, Apr FY13, May FY2014
In my source I have column with other format date (Sheet2, column B): DD-MMM-YYYY (31-May-2014 or 30-Apr-2014).
Now I want to use Match function to find owner.
Code:
=INDEX(('Sheet2'!B4:B1000=C17)*('Sheet2'!D4:D01000=C20)*('Sheet2'!BJ4:BJ1000))
How I need to write proper function to find owner??