vlookup help on 2 sheets

[srgsng25]

i am build a rpg character sheet and need to validate 2 sheets and rerun a value form bases on vlookup

base code so far
=VLOOKUP(B46,weapons,2,FALSE) then =IF(ISNA(VLOOKUP(U24,skillstable,{3,4},TRUE)),"",SUMPRODUCT(VLOOKUP(U24,skillstable,{3,4},TRUE)))

what this need to do is when my player select a "gun" in the drop down it till search table 1 & table 2 for "gun" if they are equal it will return the value of table 3