LindaGibson
New Member
- Joined
- Jul 28, 2004
- Messages
- 5
I have a spread sheet listing types of paper, (4) vendors and their price for such. I want the last column to show who has the lowest price.
columns are:
paper / weight / Vendor 1 price / Vendor 2 price / Vendor 3 price / Vendor 4 price / Best price
I want a formula that will lookup and compare all 4 vendor's prices (columns C, D, E & F) and have their name be inserted in column G (as follows)
Vendor1 = JC
Vendor2 = UNI
Vendor3 = SP
Vendor4 = XPX
how would I do that?
Thanks so much!
Linda
columns are:
paper / weight / Vendor 1 price / Vendor 2 price / Vendor 3 price / Vendor 4 price / Best price
I want a formula that will lookup and compare all 4 vendor's prices (columns C, D, E & F) and have their name be inserted in column G (as follows)
Vendor1 = JC
Vendor2 = UNI
Vendor3 = SP
Vendor4 = XPX
how would I do that?
Thanks so much!
Linda