VLOOKUP - used with INDIRECT...

[Aitch]

Would be grateful for some help please!

I'm using this formula

=VLOOKUP (I2 , OLD!H$2 : OLD!M$2000 , 6 , FALSE)


I'd like to be able to input different values into the formula by using cells A1 A2 A3 A4 like this:
A1 = the I in I2
A2 = the H in OLD!H$2
A3 = the M in OLD!M$2000
A4 = the 6

How do I use INDIRECT properly to make this work, all my attempts keep showing an error!

=VLOOKUP (INDIRECT(A1)&"2 , OLD!"&(A2)&"$2 : OLD!"&(A3)&"$2000 ,"&(A4) ", FALSE")

Thank you!

 

[Aitch]

Considering those formulae make absolutely no-sense, I have no idea.

Well if a genius like you can't figure it out - there's absolutely no chance I ever will!

Thanks again!