Comparing vendor RFPs

I have a collection of data for multiple vendors with one column on the end for a manual input of the winning vendor. Presumably all vendors will bid on all projects, so I will have F3 through U41 all filled out with column V the manual plug.

My question is, on another tab, is there a formula that combines IF, INDEX, MATCH, etc, or would I just have to nest all of these to return what I want?

And further, I can't see how I would need to write this to not have blank spaces in it.

I have a summary tab that I have thrown in a drop down list for all of the vendors.

What I want to do in words is this:

When the menu is filtered to display Vendor X, I want cells D8:D(however many projects there are) to go lookup if there is a value in that respective vendor's listing of bids provided. The way it is set up, a VLOOKUP won't work. Then in the adjacent column, I want to perform the same type of lookup, but instead vendor specific, I want it to return the lowest bid offered so I can compare the two.

Does any of this make sense?

Thanks

Probably but your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Prob best post a dummy spreadsheet. . .

. . .and change the post title of the thread before. . .

That concisely?

Try something like: Compare bids of multiple vendors

Also an example as Special-K suggested.
Make sure to hide private informations.

Please post workbooks, not pictures.

Row\Col	A	B	C	D	E	F
1	Job	'Po	Lowe's	Tgt	Winner
2	A	1	2	3	'Po	E2: =INDEX($B$1:$D$1, MATCH(MIN(B2:D2), B2:D2, 0))
3	B	2	3	1	Tgt
4	C	3	1	2	Lowe's

Read the forum rules and you'll kill all those birds with one stone.