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