samilynn
Board Regular
- Joined
- Jun 24, 2003
- Messages
- 166
- Office Version
- 2016
- Platform
- Windows
Hi, I am struggling to come up with the formula to show me the name of the lowest vendor for each SKU (as in the last column in the example below)
If there is a way to do this, can you give me some guidance please?
Thanks!
Samantha
If there is a way to do this, can you give me some guidance please?
Thanks!
Samantha
SKU | VENDOR "A" | VENDOR "B" | VENDOR "C" | WHO IS LOWEST? |
A123 | $1.00 | $1.25 | $1.50 | VENDOR "A" |
A555 | $10.00 | $9.00 | $9.50 | VENDOR "B" |
B456 | $0.15 | $0.17 | $0.10 | VENDOR "C" |
B666 | $6.21 | $6.18 | $6.99 | VENDOR "B" |