Originally Posted by

**facmess1**
Hi, I am trying to create a formula that will look for a value "BL" in a cell and if it is not found, return a number for that cell.

If the cell is "BL" then the number is the lookup cell needs to be divided by a quantity (another cell) and then multiplied by a static number.

If the cell is not "BL" then a vlookup is done to pull back a number from another spreadsheet that corresponds to what the value is looking up.

so far, this is what I have in two cells and each work but I cannot figure out how to combine them into one function.

=IF(LEFT(D2,2)<>"BL",VLOOKUP(D2,'Master Resource Generic Rates'!A:C,3)*'106979Sep06Actuals Extract_TO11'!F2)

=IF(F2<>0,(G2/F2*2.44),IF(F2=0,G2))

I have tried using OR but am not that familiar with it and am at a roadblock.

Any help would be appreciate.

## Bookmarks