View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scott scott is offline
external usenet poster
 
Posts: 577
Default I want to look up a cost but I need two criteria met Vlookup give.

I have a table and want to find One cost but it must meet two values. ie
Task number plus Labor = Cost or Task number plus material = Cost. Vlookup
seams to only want to lookup one of the two values then return the cost