vlookup with a twist maybe?

[dannykennedy]

Can someone help me please,
I am looking to do a vlookup but return a cell 5 columns across and 4 down from the match of the vlookup? Any possibilty?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>Thanks
Danny

 

[Jonmo1]

Welcome to the board...

Instead of Vlookup, try

=INDEX(F:F,MATCH(A1,B:B,0)+4)

It will find the match for A1 in Column B
Return the value in column F(5 columns accross)
And 4 rows down (the +4)

Hope that helps.

 

[dannykennedy]

Brilliant thank you this works perfectly