Populating data from a master list

I would like for any barcode that is entered on sheet 1 column B (that is from a master list on sheet 3 with the Main category in column F (not a bar code) and the subcategories in columns G - K (these are the barcode entries).
Once it is entered I would like for it to automatically populate the PLACE (Main Category) in column A on sheet 1. Sheet three has the places in column F but the hard part is that each place has 5 different possibilities (the barcodes). I have attached a sheet and the final project should look like I have it.


Thank you for any help

It is not clear from the request, if you want to do partial or full match.

I would prefer a full match

Well! There is only a single full match as per attached.

Does this help?

In your original attachment, there was a single cell to search. I have now modified it to search through column B.