Make fill in cells behaive

  • Thread starter Thread starter frogman
  • Start date Start date
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.
 
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))
 
You must log in or register to reply here.

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

Similar Threads

Finding value using greater than, Vlookup, and nested If 2
Duplicating cells with formula's 3
Excel formula referencing cells 4
Changing font color based on type cell it is. How to do it? 6
Fill cells increment row number i fomula 1
Vlookup and multiple data 5
dragging a list of numbers/repeat vs. iteration 4
Please help with Excel Formula 2

Back
Top