How to comparing a value with multiple rows.

[arfanvilla]

I have a table of data and am looking to compare a particular row that is unknown with another row.

Example:

. ------ A ---- B ---- C ---- D ---- E ---- F

1 ------ 1 ---- 2 ---- 3 ---- 4 ---- 5 ---- ?
2 ------ 6 ---- 7 ---- 8 ---- 9 ---- 10
3 ----- 11 --- 12 --- 13 --- 14 --- 15
4 ----- 16 --- 17 --- 18 --- 19 --- 20

The value of F1 corresponds with row A and will determine which row to use in the table, eg if F1 = 6 then the row used will be A2:E2. This row will then be compared with another using the Lookup function.

My problem is how do I find which row in from column to use from the value in F1. I've tried using the lookup funtion but I am struggling slightly.

Hope I've been clear enough for someone to answer. Thanks.

[starguy]

There is some ambiguity in your question. Please attach a sample file in zip format explaining your requirement.

[arfanvilla]

Hope this helps.

[arfanvilla]

problem solved, i used a different more simpler way around the problem. thanks anyone who had a look anyway.

[loloelpalomero]

It would be a great help for other users that you post your answer to your own question. I've found your question searching in the forum and it matches my needs... But no answer is given.

Could you...?