Share via

Index & match function Error

Anonymous
2024-12-12T15:13:27+00:00

Index / Match function Error

File in the following link "column I" is derived with Index/ match & vlookup functions. It seems that there is some mistake as the values what is supposed to be is not as required. The required value has been populated in "column J". Appreciate the solution and help me understand what is going wrong with the formula given.

Thanks in advance!

https://1drv.ms/x/c/5184dd66ded11ae2/EaIKCfO50R5DgFBBvbN9OPEBdGieXJkY3GQIgLPaJ6cNqw?e=HW9lt1

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2024-12-12T19:47:51+00:00

    Thank you. The first range in the INDEX part should be Backup!$S$2:$S$1000 to correspond to the ranges in the MATCH part.

    =IFERROR(VLOOKUP(B2&H2,Backup!$A:$D,4,FALSE)&"-"&VLOOKUP($C2,Backup!$F:$G,2,FALSE)&"-"&INDEX(Backup!$S$2:$S$1000,MATCH(1,(F2=Backup!$P$2:$P$1000)*(E2=Backup!$Q$2:$Q$1000)*(G2=Backup!$R$2:$R$1000),0))&"-T13-I002","")

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-12-12T15:32:08+00:00

    That link requires login.

    Thanks for notifying ... The link is updated now.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2024-12-12T15:21:15+00:00

    That link requires login.

    Was this answer helpful?

    0 comments