- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Microsoft Excel Question.. What formula do I need?
Posted on 3/8/19 at 3:39 pm
Posted on 3/8/19 at 3:39 pm
I have a spreadsheet for my farm that lists chemical vendors in B1:F1. In B2:F2, are each vendor’s price of an identical product given to me. I have the MIN(B2:F2) formula in G2 and it obviously tells me what price is the lowest.
I’d like a formula in H2 that tells me which vendor had that low price in G2. For example, if the low vendor in B2:F2 is D2, then D1 has won my business for that product. In H2, I want the name of the company in D1.
This is probably not very difficult, but I’m on an iPad, and Excel on an iPad is still new to me so I’m hoping that someone here can point me in the right direction.
I’d like a formula in H2 that tells me which vendor had that low price in G2. For example, if the low vendor in B2:F2 is D2, then D1 has won my business for that product. In H2, I want the name of the company in D1.
This is probably not very difficult, but I’m on an iPad, and Excel on an iPad is still new to me so I’m hoping that someone here can point me in the right direction.
Posted on 3/8/19 at 3:47 pm to prostyleoffensetime
Vlookup might do it. Look that up in help and it should tell you the correct argument structure. Not sure but you may have to switch columns as vlookup only looks right.
quote:
VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.
This post was edited on 3/8/19 at 3:56 pm
Posted on 3/8/19 at 3:59 pm to prostyleoffensetime
Put this in H2
=INDEX(B1:F1,MATCH(G2,B2:F2,0))
=INDEX(B1:F1,MATCH(G2,B2:F2,0))
Posted on 3/8/19 at 6:00 pm to Chinese Bandit
Or in H1:
=INDEX(B1:F1,MATCH(MIN(B2:F2),B2:F2,0))
=INDEX(B1:F1,MATCH(MIN(B2:F2),B2:F2,0))
This post was edited on 3/8/19 at 6:01 pm
Posted on 3/8/19 at 7:22 pm to nctiger71
Vlookup would only work of the prices are all unique.
Posted on 3/9/19 at 1:46 pm to Chinese Bandit
quote:
=INDEX(B1:F1,MATCH(G2,B2:F2,0))
This did the trick. Thanks.
Popular
Back to top
Follow TigerDroppings for LSU Football News