Excel Formula-Return Value based on looking at two separate values (either/or)

I am using this formula to retu a value from table below:

=IF(ISNA(VLOOKUP(A2,USUB,1,FALSE)),"No Fruit Found",VLOOKUP(A2,USUB,2,FALSE))

USUB table has this data:

Fruit Fruit Code FruitID Location CITY Apple APP A SEATTLE,WA SEATTLE Bananas BAN B MODESTO,CA MODESTO Cherry CHER C CHARLESTON,SC CHARLESTON Blackberrires BLCKB D VICKSBURG,VA VICKSBURG Blueberries BLUB E SAN DIEGO,CA SAN DIEGO Cantaloupe CANT F GULF SHORES, AL GULF SHORES Grapes GRP G NAPA VALLEY,CA NAPA VALLEY Peach PCH H ATLANTA, GA ATLANTA Grapefruit GRPFRT I FT LAUDERDALE, FL FT LAUDERDALE Pomegranate POM J HONOLULU, HI HONOLULU

Kiwi KIW K SALEM, OR SALEM

What formula would I use to first look at Fruit (USUB,1) and then Location (USUB,4) and retu a value of Fruit Code (USUB,2) based on the criteria in the formula?