• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

matching query not working

I am using the formula
= match((C7,A1:A670)
but when I copy down its carrying (C7.A7:A677)
how do I stop this here is the file attached. match-formula.xlsx
0
Amanda Walshaw
Asked:
Amanda Walshaw
1 Solution
 
NorieCommented:
In the formula bar select the 2nd argument of the formula, A7:A677, and press F4 to make it absolute.

The formula should look like this now:

= MATCH(C1,$A$1:$A$670)

Then it won't change as you copy the formula down.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now