Vlookup inconsistent formula

Hi All,

I am trying to drag a vlookup formula across several cells and eventially over thousands. However i cant seem to get a consistant sequential formula the way i want it.

I have attached my document to this post.

for example in cell AG i have this

=VLOOKUP(N1,INDIRECT(A2),2,FALSE)*N2

as i drag this across to cell AH the INDIRECT(A2) changes, i want it to remain (A2). However when i want to drag the formula down to the next cell i want it to change to INDIRECT(A3).. and so forth.

Can someone help me to achieve this please? or give me some better ideas.


thanks

Aboo

Hi Teylyn,

Thankyou for your reply, this will work when im dragging the forumla across, however when i want to drag the formula down i want N1 reference to stay and if i drag across i want the N1 reference to change to O1, how can i achieve this?

Thank you for your help