Need formula help - IF AND, Then Vlookup

Have a table like this:

WHS Item Desc OnHand InTransit POopen SOopenB/O Allocated Avail UnAvail
FBDH GCGD18S21S2XE 1.5T 1 0 0 0 1 0 0
FBDH GCGD42S21S2 3.5T 0 0 0 0 0 0 1
FBDH GCGD42S21S2E 3.5T 0 0 6 0 0 0 0
FBDH RAC13J244S21 2.0T 2 0 0 0 2 0 0
FBDH RAC13J364S21 3.0T 1 0 0 0 0 1 0
FBW1 YCJD24S41S1 2.0T 1 0 0 0 0 1 0
FBW1 YCJD48S41S1E 4.0T 1 0 0 0 0 1 0
FBW1 YCJD60S41S2 5.0T 0 0 0 0 0 0 1


Trying to autofill a table like this:
FBDH FBW1 FBW2
GCGD18
GCGD24
GCGD30

So if value in 1st table equals "FBDH" and the model "GCGD18", then return value 9th to the right.

I tried an IF, AND with VLOOKUP, but I can't get it to work. HELP!!!

I'm not exactly sure what you are asking, please try attaching a workbook with more entries so we can see what you are asking.

Under advanced (after editing post), scroll down to manage attachments and upload a workbook with sample data.

However, as a guess as to something that could possibly help, try highlighting your C column and inserting a new column. Then, highlight your B column and go to data > text to columns.
Select fixed width > next > click after the character you are calling the "model" then hit finish. This will divide your item number into what you want (I think) and will allow you to lookup easier?

If I am misunderstanding, please upload a larger sample size, and possibly a desired output in a different tab.

See attached to see what I'm looking for. I really appreciate the help!

It worked! You're the man, I love you! LOL.