[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
Solved

# matching query not working

Posted on 2011-09-15
Medium Priority
219 Views
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
Question by:Amanda Walshaw
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 35

Accepted Solution

Norie earned 2000 total points
ID: 36546886
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

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
###### Suggested Courses
Course of the Month12 days, 15 hours left to enroll