Using VLookup to find closest match

I need to use VLookup to find closest match for our Online Bedding company.


Example -

Table

Short Name............................Weight
Twin Comforter..........................13
Full Comforter............................15
Queen Comforter........................17
King Comforter...........................21



Excel Data Sheet.....................Weight
Green Twin Comforter..................*Need it to auto insert 13
Full Comforter (Green)..................* Need to to auto insert 15


Any help would be great, Thank you!