Forum Discussion
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 companies I have breakdown of their pricing and want to have their specific pricing where the #REF is showing, I am thinking and if, then type formula but can't figure out the structure. PS I can't use the min formula because even though a Contractor may have an over all low number his breakdowns may not necessarily be the low item. Here is what I was trying =IF(B10=B11,F11)=IF(B10=B12,F12)=IF(B10=B13,F13)
| frm | wood | insul | gyp | gyp patch allow | dr inst | act | ||||
| Garcia Drywall | 38,609.00 | (+/- From Low) | TRUE | #REF! | #REF! | #REF! | #REF! | #REF! | #REF! | |
| Garcia Drywall | 38,609.00 | 0.00 | 8384 | 2200 | 2985 | 7447 | incl | 1050 | 16543 | |
| Level Construction | 40,600.00 | 1,991.00 | 7200 | 4300 | 2900 | 6200 | 2500 | 2500 | 15000 | |
| Wall Services Group | 42,300.00 | 3,691.00 | 8500 | 4200 | 3000 | 6800 | 2000 | 1800 | 16000 |
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.
5 Replies
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.
