Using INDEX over entire workbook

Question

Is it possible to use INDEX formula over the entire workbook with the same reference cell on all?

Answer 1

You're right Ashish!

I'm not sure if anyone will go for it but what I did was I created a link of the same cells on a separate sheet (hidden) and used the VLOOKUP to complete the task.

It worked the way I wanted.

Thank you for all your help.

Answer 2

The rows I selected were only for testing purposes. I will increase it if I find a way to included all the worksheets. Otherwise, the formula is useless. :)

Thank you!

Answer 3

Hi,

There is a problem in your INDEX() formula.  If the array is only one row high i.e. row 5, the row index must be 1.  Also the last argument of the mATCH() function must be 0.  Did you mean this instead

=INDEX('1'!M5:P5,1,MATCH(Errors!A5,'1'!F4:G4,0))

Answer 4

Thank you Bernie,

I used INDEX on the last sheet (Errors) of my workbook that references to a cell on the 1st worksheet. However, I want that INDEX spread over the entire workbook to recognize the same cell on all of them and give me the value that it refers to:

=INDEX('1'!M5:P5,MATCH(Errors!A5,'1'!F4:G4),1)

That way if I type a number on A5 of the Errors sheet it will look for the same value across all of the worksheets and give me the value I'm referencing.

I hope this was a good enough explanation. If you think you need more just let me know.

Robbie

Answer 5

Yes. Maybe. Or No. You need to better explain what you want to do.