Thread: Formula to return under-budget store locations
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Craig Josh Craig is offline
external usenet poster
  
Posts: 40
Default Formula to return under-budget store locations
oops! one modification- the formula should be:

=IF(C2<VLOOKUP(A2,Sheet2!A$1:B$5,2,FALSE), "UNDER BUDGET","OVER OR ON BUDGET")


Reply With QuoteReply With Quote