I want to apply -1 offset to the INDEX & MATCH result on Sheet 1 A2. OFFSET will happens on the table sheet 3 row 9.
So on the cell A2 G3 will be F#3 after OFFSET applied.
Resource Data are on the Sheet 2 and 3
How can I do that?
I want to apply -1 offset to the INDEX & MATCH result on Sheet 1 A2. OFFSET will happens on the table sheet 3 row 9.
So on the cell A2 G3 will be F#3 after OFFSET applied.
Resource Data are on the Sheet 2 and 3
How can I do that?
PerhapsFormula:Please Login or Register to view this content.
Last edited by Pepe Le Mokko; 10-28-2020 at 01:59 PM.
Maybe like that?
in A2:
=INDEX(Sheet3!$A$9:$Y$9,,MATCH(Sheet2!A2, Sheet3!$A$9:$Y$9, 0)-1)
Thank you very much. They work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks