MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12
Return Post new threads
Author: AlexObl

Help with making excel forumla(s)

[Copy link]

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-10-2017 06:51:00 | All posts



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?




Reply Support Opposition

Props Report

4

Topics

181

Posts

440

Integral

Conqueror

Rank: 3Rank: 3

Integral
440
Post on 2-10-2017 07:25:12 | All posts



You have to define closest what is the criteria?




Reply Support Opposition

Props Report

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-10-2017 07:31:54 | All posts



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
Reply Support Opposition

Props Report

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-11-2017 18:28:40 | All posts



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




Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 2-11-2017 19:44:08 | All posts



I'm afraid I'm not sure how to go about getting closest matches.
Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 2-11-2017 20:41:49 | All posts



I'm afraid I'm not sure how to go about getting closest matches.









Reply Support Opposition

Props Report

6

Topics

857

Posts

1900

Integral

King

Rank: 6Rank: 6

Integral
1900
Post on 2-11-2017 21:41:56 | All posts



It would be easier if you put the dimensions in separate columns.
Does closest mean minimum size = each required dimension, or something else?
Reply Support Opposition

Props Report

12
Return Post new threads

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 11-20-2017 10:07 , Processed in 0.151508 second(s), 17 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!