Conditional Filling

  • Thread starter Thread starter StevenAFC
  • Start date Start date
S

StevenAFC

Hey

Ive got a formula that searchs another worksheet, between A1 and B250
and automatically searchs the number in the cell next to it...

=INDEX('Customer Table'!A1:B250,MATCH(A1,'Custome
Table'!A1:A250,0),2)

Now I want to apply that to every cell vertically, by filling (draggin
that little black box) all the way down.

However it results in this....

=INDEX('Customer Table'!A10:B260,MATCH(A10,'Custome
Table'!A10:A260,0),2)

It changes the search area, which breaks everything. I only need it t
increase the field in which it takes the search info.

How can i do this
 
Use absolute references:

=INDEX('Customer Table'!A$1:B$250,MATCH(A1,'Customer Table'!A$1:A$250,0),2)

Regards,
Stefi

„StevenAFC†ezt írta:
 

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

Excel Conditional Formatting 1
Validation list with array formulaes 6
I think an easy Conditional Formatting ? 4
Conditional color fill 4
Fill Help 3
Problem with MATCH function 5
mr t.valko ..help 8
Versatile "adaptive" formulae? (instead of "hard"coded IF tests) 1

Back
Top