Need a formula to return a specific value based on the potential combination of 2 cells

Need a formula to return a specific value based on the potential combination of 2 cells - after a vlookup.

So Currently have a vlookup mapping 1 column to certain categorie
need it to say then - after doing that lookup - if 2 cells contain certain text - then the return value is X.

Thanks!! So the vlookup is the main mapping formula then was hoping to build on top of that to say ALSO if 2 other cells have certain text to change the output, maybe I need to rethink formula. But now I have:


Tab 1: holds the data looking up to (E:K)

Tab 2: H1 = IFERROR(VLOOKUP(F2,'Job Type Mapping (Input)'!$E:$K,7,0),"")

+ now trying to say in addition to this vlookup , look at the combination of Cells F1 AND G1 = IF they say:
F1: JA & G1: PX THEN H1: now says: XYZ

Does that make sense? Thanks sooooo much for your help!

Try it like this:

H1 = IF(AND(J1="JA",G1="PX"),"XYZ",IFERROR(VLOOKUP(F2,'Job Type Mapping (Input)'!$E:$K,7,0),""))

Hope this helps.

Pete

YESSSSSSS - you saved me TYTYTY