Make fill in cells behaive

F

frogman

I have a formula:
=IF(ISNA(VLOOKUP(C8,Sheet2!A3:B9,2,0)),"No
Match",VLOOKUP(C8,Sheet2!A3:B9,2,0))

When I pull down the autofill i want the C8 to increment by 1 but the
Sheet2!A3:B9 to remain constant.

I have looked on google and MS but cant find what i am looking for.

Is there any way to do this.
 
M

mudraker

Use $ symbol in front or each row or column that you do not want to
change

c8 becomes c9 when dragged down
c8 becomes d8 when dragged to the right

c$8 stays c8 when dragged down


=IF(ISNA(VLOOKUP(C8,Sheet2!$A$3:$B$9,2,0)),"No
Match",VLOOKUP(C8,Sheet2!$A$3:$B$9,2,0))
 
Top