View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Billing Goddess
 
Posts: n/a
Default Vlookup for multiple selections

I hope someone can help!

I have the following data

col K col L col Q

40066 $2000.00 80962
40066 $10,000.00 80963
40066 $5.00 80964
40067 $75.00 80966
40067 $20.00 80900
40068 $2200.00 80901

I need the value in col L if col k is 40066 and col q is 80964. All values
are always within one row, meaning that if 40066 and 80964 are found, the $$
will be in that row also. Does this make sense??

--
Many Thanks,
Paula