Thread: Using vlookup with the IF function
View Single Post
 
Old 03-25-2012, 12:28 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
  
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default
In case you really do not want to create the hidden columns here are the 2 formulas

For the Crew size
=IF(C2=4600,VLOOKUP(F2,W$5:Y$11,2,0),VLOOKUP(F2,W$ 12:Y$18,2,0))

For the Rate
=IF(C2=4600,VLOOKUP(F2,W$5:Y$11,3,0),VLOOKUP(F2,W$ 12:Y$18,3,0))

The problem with this if you have more than 2 part number it will not work. You could write an addtional formula at the beggining of the if formula but again I think it would be easiest with the 2 columns.

Lastly you may want to look into adding a dropdown list for the job field to speed things up but after you enter the same job twice it will autofill in.

Let us know what you come up with.
Reply With Quote