Look Up for double criteria in different rows

[justinab01]

Hi there

I need to create a look up to find a value from an exported table using two criteria that also isnt consistent in that the number of rows can be different.

My export file has a long list of similar tables for different individuals. In the example below I want to return the value in for Person A's 'Breaks', which currently resides in F9, 80%. What makes this more difficult is that the export table may sometimes have additional rows meaning that the 'Breaks' figure wont always be in the same place and could be bumped to row 10 or 11 although it will always be in column F. I want to then repeat this formula for Person B, C, D etc.

A B C D E F G
1 Person A Date
2
3 Adherence -
4 Scheduled Scheduled Actual Min. In Min.Out Perc. In +/- Min.
5 Activities Time Time Adhere Adhere Adhere Conform
6
7 Sign On 07:40 09:52 445 15 97% 132
8 Sign Off 00:00 00:00 0 134 0% 0
9 Breaks 01:05 01:07 52 13 80% 2
10 =========
11 Total 08:45 10:59 497 162 95% 134

The 'Breaks' column will be repeated for all the other individuals so Im not certain then word 'Breaks' can be used in the LookUp for this reason.

Any ideas? Thanks

[davesexcel]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic