HELP NEEDED

[ONKAR BHOSALE]

I have one problem while finding the closest possible match with certain value and I want value from adjacent cell should be executed on sheet.
For example I hav attached below sheet where i want GENERAL STORAGE VOLUME 160
should be checked in Jth column for nearest largest value and corresponding BIN name from C column should be executed.Data in column is not in ascending order so facing problems while solving this..I HAVE ATTACHED SHEET FOR THE SAME


s

 

[NARAYANK991]

Hi Bhosale ,

It would have been better if you could have explained your requirement with at least a couple of examples ; as it stands , others will have to ask questions , wait for your answers , and then try and solve your problem.

Suppose we take the data given in your worksheet ; are we to look for the closest match for 160 ? If so , would it be 260 in the case of Supreme and 163 in the case of Nilkamal ?

Narayan

 

[ONKAR BHOSALE]

As per your requwst i am again explain what i am looking for
@NARAYANK991
I just want value mentioned(for example 160 in pic) should be checked in last coulmn of both supreme and nilkamal (seperate result for both supreme and nilkamal is also helpful) in this example answer for supreme will be 260 so the subjected value of bin should be reflected which is BIN-35 in this example
similarly for nilkamal it is FPO CRATE15


This whole problem is about finding best match bin for any part on assembly line(nut,bolt etc.)so a person will only fill dimension in upper two cells (B4 and C4 in this example) and as per calculation i made last column is giving approx number of quantities which can be placed in each of bin.here D4 contains value which in general stored in that bin.So Final result should be the name of bin of best match



Please feel free to ask any question about the problem if u still have any

 

[NARAYANK991]

Hi Bhosale ,

See if this is OK.

Narayan

 

[ONKAR BHOSALE]

@NARAYANK991
thanx a lot for your help

 

[John Jairo V]

Hi @ONKAR BHOSALE (and @NARAYANK991)

Another option in the file. God Bless You!