New Leaf

you need a vlookup formula with a hlookup formula nested within it to tell it how many columns to count across from the column with the x value in. you'll need a new row just under the one with the y value in, that just counts up, 1,2,3,4 etc. Its this row that you reference with the hlookup formula.

Well i know what i mean anyway - lol.

I'd do it for ya, but i'm on an old laptop with no excel. If you want to e-mail me the spreadsheet i'll do it as soon as i log on at work tomorrow. would only take a min. drop me pm if u want my e-mail address.