'My INDEX MATCH array function only returns #N/A on Excel 2010
I am using the following formula:
{=INDEX(PlateDetails[Height],MATCH(1,('Raw Data'!$A$2:$A$30000=PlateDetails[MRS Plate ID])*('Raw Data'!$C$2:$C$30000=PlateDetails[Room Name])*('Raw Data'!$G$2:$G$30000=PlateDetails[Place Location]),0))}
My aim is to match three columns (Plate ID, Room Name, Place Location) on two different tabs (Plate details and Raw Data), and return the corresponding value in column Height. However it only returns #N/A.
Can someone help please?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|