View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Josh Johansen Josh Johansen is offline
external usenet poster
 
Posts: 72
Default VLOOKUP using two criteria

I have a list that I want to use VLOOKUP on, what I need to do is use two
columns to perform the lookup because there are examples where there are
exact matches in the first column and then I need to use the second column to
help select the right value for VLOOKUP. I am trying to use two VLOOKUPS, as
well as use an IF statement but am struggling to make it work. Any
suggestions?