Forum Discussion
Solved
Iusing IF formula
I'll try to be as brief as possible...I've gotten this far the top line reads the min of the three lines below it. The name of the company reads the match for the min amount. For each of the compan...
It seems that you want to display the details for the lowest bidder on row 5. Since you already identified which company that is through B5 and C5, I believe you can enter the formula below in F5
=VLOOKUP($B$5,$B$6:$N$8,COLUMN()-1,0).... and copy it across to N5.
It seems that you want to display the details for the lowest bidder on row 5. Since you already identified which company that is through B5 and C5, I believe you can enter the formula below in F5
=VLOOKUP($B$5,$B$6:$N$8,COLUMN()-1,0).... and copy it across to N5.
