I create a simple search box, BUT PROBLEM IS

[firstWeMeet]

Here is my search box.
search box is in sheet1
columnA columnB
A1 = text (description) and B1 = cells with data validation (source from sheet2 description column)
A2 = text (current total qty) and B2 = =IF(B1="","",VLOOKUP(B1,Table1,3,0))
A3 = text (Unit Price) and B3 = ongoing
A4 = text (total stock cost) and B3 = ongoing

here is my problem:
the setup is columnB sheet1 has the formula showing all search data. but as you can see B2 formula, its not working. data source is from sheet2 in a table, anyone can give me the best suggestion and formula?

 

[firstWeMeet]

Anyone know help me out of here?