Hey all,
I was wondering if there was a way to get the match function to look over a grid of cells (A2:D7) rather than just a row or column?
I was looking to use a combination of Index and Match to look for a value inside a grid of cells (using match) and return another value (specifically a date) from the top row of the same column that the matched value was found.
Anyone know if this is possible using these functions, or alternatively another method of achieving this result?
Thanks in advance.
Tak
I was wondering if there was a way to get the match function to look over a grid of cells (A2:D7) rather than just a row or column?
I was looking to use a combination of Index and Match to look for a value inside a grid of cells (using match) and return another value (specifically a date) from the top row of the same column that the matched value was found.
Anyone know if this is possible using these functions, or alternatively another method of achieving this result?
Thanks in advance.
Tak
