Excel 2007 : #Value

[Leate]

=IF(Store_List[Sales]>0, VLOOKUP('Groccey List'!C2,Store_List,8,FALSE), VLOOKUP('Groccey List'!C2,Store_List,7,FALSE))

I want the formula to be used only if their is a sale going on within the row for that product, if true it will use the sales price, if false it will use the regular price.

[mudraker]

Welcome to Exceltip forum

Please take a couple of minutes and read ALL the Forum Rules then edit your thread title by following the instructions in the rules (Rule 1) so that it better discribes your problem/request