Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following data in a sheet called growers
Col A Col B Col C Grower Name Product Size Price There are 44 rows of data in total In a second sheet I have setup drop down lists to select the Grower Name in Col A and Product Size in Col B. I have entered the following function into another column in cell H2 {=INDEX(growers!C2:C43,MATCH(1,(growers!A2:A43=A2) *(growers!B2:B43=B2),0))} which matches the price accordingly. I've then copied the function down column H and everything seemed to be working fine. My issue is that when I get to cell H35 (and onwards) I get the #N/A from that row onwards. Here is the function as it is in cell H35 {=INDEX(growers!C33:C76,MATCH(1,(growers!A33:A76=A 35)*(growers!B33:B76=B35),0))} I have a feeling it has something to do with the lookup array value, however I can't work out how to fix it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX MATCH #N/A Error | Excel Worksheet Functions | |||
VALUE error with index(row.. match(true.. row.. | Excel Discussion (Misc queries) | |||
Error suppressing with INDEX/MATCH | Excel Worksheet Functions | |||
VLOOKUP, INDEX & MATCH ERROR HELP | Excel Worksheet Functions | |||
#num Error index, match | Excel Worksheet Functions |