Help with making excel forumla(s)

Hello there!

I have no idea if this is even possible with excel but here it goes:



I'm trying to make it so when you enter a products measurements it will tell you give the product name and manufacturer. (with multiple suggestions if possible)



E.g i type in 420x420 i want it to come up with who produces a product that size and the name of the product.



Here's a picture of what i mean:

http://imgur.com/a/jMS4V





Any help is greatly appriciated

Kind of but not exactly what im looking for, id like to so that when you type in the measurements e.g 100x200x300 it would show you the product(s) closest to those measurements. Is that even possible in excel?

You have to define closest what is the criteria?

as in if i type in 100x200x300 it would show you the product which matcheos that measurment but thatit also would show you the ( for example) 3 closes products to that measurm0000000ent e.g 110x200x300 150x200x300 175x200x300