Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Excel 2007.
I have two worksheets named "Open 1st Go" & "Open 2nd Go". The first worksheet contains Column A (Rider), Column B (Horse), Column C (1st Go Time), Column D (2nd Go Time), and Column E (Average Time). The second worksheet contains Column A (Rider), Column B (Horse), and Column C (2nd Go Time). I need to match the rider/horse from the 1st go sheet exactly to the rider/horse on the 2nd go worksheet (as some riders ride more than one horse and therefore would have a different time) and bring back their 2nd go time into Column D. This is the formula that I used, but it only matches the rider, not the combination of rider/horse, and brings back only the one time not distinguishing between different horse names. =INDEX('OPEN 2ND GO'!$A$1:$C$34, MATCH(A2,'OPEN 2ND GO'!$A$1:$A$34,), MATCH("TIME",'OPEN 2ND GO'!$A$1:$C$1,)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DSUM Criteria - find exact match only | Excel Worksheet Functions | |||
Find exact match, same workbook, different sheets | Excel Discussion (Misc queries) | |||
Find a not exact match using vlookup | Excel Discussion (Misc queries) | |||
using vlookup to find exact match | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions |