Vlookup help required

[doris_day]

I want to use vlookup (or similar) on a page with multiple Correct Score markets.

I know how to use vlookup when all the data you're after is on one row but how do I point to data that's on other lines ? For instance, say I find my market, like Sweden in A1 but I want my cell with the formula to load the data from cell F5 (0-0 back data), which is Offset from A1 by 5 columns and 4 row. Can I use the Offset function within the vlookup formula somewhere ?

Any assistance would be grateful.

[osknows]

Hi doris,

Both of these formulae will offset a string match of Sweden in cell A1 to F5

=INDEX(A:F,MATCH("Sweden",A:A,0)+4,6)

=OFFSET(A1,MATCH("Sweden",A:A,0)+3,5)

[doris_day]

That's great Os. Just what I needed.