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
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