Tech Support Guy banner

Excel Database Help

1808 Views 20 Replies 5 Participants Last post by  Zack Barresse
I am working on a database where A1-A1500 contains part numbers. Columns B-BX contain "Vendor Price" and "Date Price was Quoted" for multiple vendors. I inserted 2 columns at Column B and added "Best Price" into Column B and did MIN function to find the lowest price. Ok, that was the easy part.

Now I would like to/have to work out some logic so the database knows which Vendor did have the lowest price because I need to have the "Date Price was Quoted" that is associated with the "Best Price" fill into Column C. I think this is a combination of a VLookup and an if then statement, but I am not sure how to approach it and I am stuck! Help!

I appreciate any insight/advice..
Thanks for your time,

Not open for further replies.
1 - 2 of 21 Posts
No VBA needed, just enter this formula in B2, copy down...

Thanks! I probably could have shortened it with a defined name, but I shy away from them unless really needed. I'm sure there are better ways, but it works. :)
1 - 2 of 21 Posts
Not open for further replies.