Good afternoon,

I am trying to complete an index & match query to return a title from column "H" based on the following criteria

M20 - Book type (hardback or Paperback)

M21 - cost to me

N21 - cost to customer

M20 And column "H" are set as text values and M21 & N21 are as numbers

Both are done as nested formulas with Ctrl+shift+ enter

With the formulas below I get a #REF ! issue

with the below I get a #VALUE error

thanks in advance

Gavin

I am trying to complete an index & match query to return a title from column "H" based on the following criteria

M20 - Book type (hardback or Paperback)

M21 - cost to me

N21 - cost to customer

M20 And column "H" are set as text values and M21 & N21 are as numbers

Both are done as nested formulas with Ctrl+shift+ enter

With the formulas below I get a #REF ! issue

Code:

`=INDEX(C:C,MATCH(M21,H:H,0),MATCH(N21,I:I,0),MATCH(M20,A:A,0))`

Code:

`{=INDEX(C:C,MATCH(M21,H:H)*(N21,I:I)*(M20,A:A),0)}`

Gavin

Last edited: