Need help with Fill Series in vba

[greegan]

I have a table, each page of this table there are 55 rows totalling 6 pages (330 rows total).
On the first column I have a range of low and high numbers (From and Less than). For each page these ranges will increase by a specific amount. Page 1 will have a range of four where Page 2 will have a range of 8, (16, 20, 24 and so on) etc until it reaches 330 rows for that table.
I want to use dollar amount A to find dollar amount B.
B will be found in this table somewhere. B is the centre (meadian?) value within one of these ranges. Here is a range as an example...

804-812
812-820

Here the B value would be calculated as...
812-804=8
8/2=4
804+4=808

If A is to be found on the table I need to know where on the table (which range of numbers) it falls within. Lets say A = 809. Then A would fall within the range of 804-812 and I would find the value of B which is 808.

I do have more than one of these tables, and each table begins and ends with different amounts from the next table. The above is just an example.
This particular table begins with Less than 756 and ends with Less than 15488.

I would like to enter value A in cell F1 and have value of B appear in cell F2.

Can someone put me on the right track for this? I need help.

Please ask questions if you think you can help and you need more info.

Thank you,

-- g

PS
This is a better explanation for my previous question found here

http://www.mrexcel.com/forum/showthread.php?t=557050

And I'm hoping it was okay to create a new thread.

 

[greegan]

This has been resolved.