Follow this topic

AINA BINTI AZAZI

Last answered:

22 Feb 2023

Posted on:

22 Feb 2023

0

How do i do this without rewriting the formula

in Advanced Microsoft Excel / Advanced Excel Functions Index; Match; Index & Match

How do i do this without rewriting the formula? But when i wrote the formula, it still got error

1 answers ( 0 marked as helpful)

Ned Krastev

Instructor

Posted on:

22 Feb 2023

1

All you have to do is adjust the formula references:)

I'm not sure what the '8' in your formula does. Probably it is not needed.

Submit an answer

related questions

0

6

Specifying the array in Index formula

RAJAONARIVONY Tsiory Kevin

0

6

Resolved: We can just use Q_1 in the formula instead of indirect function. So why using Indirect function?

Dhruv Chaudhary

0

4

Resolved: Dragging the indirect formula

0

4

Resolved: Excel formula question

0

2

Resolved: Error with the formula Index match match