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
12Next
Return Post new threads
View: 592|Reply: 16

Help with making excel forumla(s)

[Copy link]

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
Post on 2-9-2017 13:06:10 | All posts |Read mode
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
Reply

Props Report

12

Topics

1805

Posts

3816

Integral

Forum Legend

Rank: 8Rank: 8

Integral
3816
Post on 2-9-2017 14:17:06 | All posts



A picture is not much use - you should attach a sample Excel workbook instead, and you can attach directly to one of your posts here on the forum rather than using a 3rd party site.
To do this, click on
[color=]Go Advanced
(below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on
[color=]Browse
and navigate to (and double-click) the file icon that you want to attach, then click on
[color=]Upload
and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
You also need to explain what you want to happen if the formula cannot find an exact match of the size that you enter.
Hope this helps.
Pete




Reply Support Opposition

Props Report

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-9-2017 15:03:49 | All posts



That workbook was just an example, it was empty except for that part which i showed.
If the formula cannot find an exact match it should show the closest match.
Thanks!
Reply Support Opposition

Props Report

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-9-2017 16:54:37 | All posts



That workbook was just an example, it was empty except for that part which i showed.
If the formula cannot find an exact match it should show the closest match.
Thanks!




Reply Support Opposition

Props Report

12

Topics

1805

Posts

3816

Integral

Forum Legend

Rank: 8Rank: 8

Integral
3816
Post on 2-9-2017 18:09:56 | All posts



Some contributors are reluctant, or may even not be allowed due to company firewalls etc., to download files from file-hosting sites. Even if they are able to download your file, they can't do anything with a picture to try out different formulae, so they will have to manually type your example data into an Excel sheet before being able to test out different approaches. Some are unwilling to spend the time doing this, especially as you already have an Excel file.
So, I ask you again - please attach a sample Excel workbook to one of your posts, using the method described above, and then you are likely to generate more interest in your problem.
Pete




Reply Support Opposition

Props Report

1

Topics

7

Posts

19

Integral

Member

Rank: 2

Integral
19
 Author| Post on 2-9-2017 19:33:00 | All posts



Alright thanks  its now uploaded
Reply Support Opposition

Props Report

12

Topics

1805

Posts

3816

Integral

Forum Legend

Rank: 8Rank: 8

Integral
3816
Post on 2-9-2017 16:45:10 | All posts



This is a duplicate thread, and should be deleted/ignored, as you have responses in your other thread.
Pete




Reply Support Opposition

Props Report

19

Topics

1896

Posts

4035

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4035
Post on 2-9-2017 17:46:29 | All posts



Welcome to the Forum, unfortunately this is a duplicate post and as such will now be closed, you may continue in your other thread.
Thread Closed.
http://www.excelforum.com/showthread.php?t=1173275
Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 2-9-2017 17:25:14 | All posts



Would this work? Click the drop down in cell B2 of sheet2. Select one of the options and cell C2  D2 should show the correct info. It is based off of the list on Sheet1.
AlexObl Vlookup.xlsx
Reply Support Opposition

Props Report

5

Topics

242

Posts

565

Integral

Lord

Rank: 4

Integral
565
Post on 2-10-2017 05:57:05 | All posts



Would this work? Click the drop down in cell B2 of sheet2. Select one of the options and cell C2  D2 should show the correct info. It is based off of the list on Sheet1.
AlexObl Vlookup.xlsx











Reply Support Opposition

Props Report

12Next
Return Post new threads

Points policy of this forum

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

GMT-5, 11-19-2017 16:12 , Processed in 0.211183 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!