Normally I'm somewhat adept at creating decent Excel formulas to meet my needs. However, this particular formula and its requirements have me stumped.
So I'm turning to all you Excel wizards out there for help...
I'm searching for a formula that will allow me to take 5 numbers in a single column...all in different cells, for instance:
1
2
3
4
5
and look for a specific match in an array of data on a separate spreadsheet within the same workbook, where the numbers go across:
1 2 3 4 5
The numbers in the second spreadsheet are preceded by a date, i.e. 1/1/1900.
So it looks like this:
1/1/1900 1 2 3 4 5
with rows and rows and rows of data.
If there is an exact match, I'd like only the date returned.
I've tried using MATCH, INDEX, COUNTIF, etc...but haven't been able to put my finger on exactly what I need.
Any help would be very much appreciated. Thanks in advance.
Bookmarks