Formula To Return Values in a Dynamic Cell

Worksheet Included,

I basically have this worksheet which has Cell D3 Being Dynamic. It puts the lowest cost supplier from columns H:W. If i change the prices in H:W it will bring up the lowest cost supplier in D3. Once D3 is chosen i want it to self populate F3 and G3 based off of what is in D3. This data should be pulled off from what is in the H:W columnns corresponding to the supplier in D3.


Thanks for any help ,

You would be better served by restructuring your workbook so that all supplier data is contained in a table that is in a classic database format which facilitates a look up formula.

A basic database structure is:
1. All related raw data in one worksheet
2. Top row is a header row
3. All rows below header row are records

With this structure in place you can easily extract any information you need.

Nothing to do with structure, but I agree with palmetto on that, but you could also remove the colouring. IMO only the header row should be formatted with a colour and/or Bold Font. Data should be on a clear background for clarity