Formula correction

D

deskjet830c

I use this formula to look up price on a 2nd work sheet
it works well on the first row but when i copy paste it to the next
row (I need to do this several times) I have to change part of the
formula, is there a better formula to use so I dont have to change it
each time I copy paste it,??

=(IF(A24=O!DA1,INDEX(O!B2:BH60,MATCH(C24,O!A2:A60,0),MATCH(E24,O!
B1:BH1,0)),0))
Copy paste gives me
=(IF(A25=O!DA2,INDEX(O!B3:BH61,MATCH(C25,O!A3:A61,0),MATCH(E25,O!
B2:BH2,0)),0))
I need to change it to
(IF(A25=O!DA2,INDEX(O!B3:BH61,MATCH(C25,O!A2:A60,0),MATCH(E25,O!
B1:BH1,0)),0))
(
Thanks all
 
P

Pete_UK

Change your formula to this:

=(IF(A24=O!DA1,INDEX(O!B2:BH60,MATCH(C24,O!A$2:A$60,0),MATCH(E24,O!B
$1:BH$1,0)),0))

Putting a $ symbol in front of the row or column reference means that
it will not change when you copy it.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top