Forum Discussion
Index & Match Formula Not Working
In broad terms, I'm on sheet 2 and wanting to show the contents of a cell from sheet 1. Basically, I want whatever is in column C of sheet 1 for the row that has column A in Sheet 1 matching A2 in S...
Hi,
Based on the example given by OliverScheurich​ you can use the following formula in Sheet2.
=INDEX(Sheet1!C:C, MATCH(A2 & A1, Sheet1!A:A & Sheet1!B:B, 0))If the Excel you are running is earlier than Excel 2021 then this formula must be applied as an array formula (i.e. using CTRL+SHIFT+ENTER from the keyboard). For Excel 2021 or newer versions it can be used as a normal formula (i.e. simply using ENTER only).
Hope this helps.
IlirU