=INDEX(IFNA(VLOOKUP(E2:E, output_result!A:G, 3, 0)))

Sheet 1:

Sheet 2:

I have two sheets and what I am trying to do is grab data from Sheet 2 on column G, and display it on Sheet 1 on column I. This will display only if Sheet 2 column A matches the details in Sheet 1 column E.

When I insert this formula the cell remains blank. Any idea as I don't think I made the wrong formula.

CodePudding user response：

I have already answered this on reddit.

If you are trying to grab data from column G, the index of your VLOOKUP (given your range of A:G) should be 7 not 3. Index 3 is returning the value from column C.