Using vlookup on another sheet

[Nerd1]

Hi!

How would I use Vlookup, when referring to another sheet? I need a formula to show:
- IF the serial number (E from sheet 1) is found in the sheet DUP (range - G1:J201) >>>> then return the right action (E.g. delete, Good, etc), depending on IF the ERASURE is blank, successful or failed.

File: https://1drv.ms/x/s!ArRB1Ah3M1ZqgpkOomz3zuStAiXyMw

Current formula (which isn't working)
=INDEX(DUP!H2:J201,MATCH($F2,DUP!H2:J201,0),MATCH($K2,DUP!H1:J1,0))

SHEET 1

DUP

 

[bsquad]

Hi Nerd1,


assuming you have your formula in P2 on Sheet1,

=INDEX(DUP!$H$2:$J$201,MATCH($F3,DUP!$G$2:$G$201,0),MATCH($K3,DUP!$H$1:$J$1,0))

 

[Nerd1]

It is mostly working, but there seems to be an issue! Every time a blank cell is in erasure, it does not compute properly.