I need to write a program for construction estimating for my company.
Nothing fancy, justa little something to make my life easier. Since I
never know how many items I will need to lookup, I want to have the
userform update the excel cells as needed.
Here is the code I am trying to get to work. It looks at the previous
cell in the row for a match description. If it finds one, I need it to
lookup the value in the pricing database and return the value in the
cell.

=IF($K18="","",VLOOKUP($K18,'C:\Templates\pricing. xls'!OIGDB,3,FALSE))

example
Lets say in the description cell it finds "30 year shingles"
It then goes to the pricing database and findes "square foot" for
column 3 so will show "square foot" in the cell.
I hope this makes sense.

Thank you for any help.
Rob