View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mel[_8_] Mel[_8_] is offline
external usenet poster
 
Posts: 1
Default VLOOKUP in Excel

I am using vlookups to create a table based on s_codes, but now I have the
added complexity where I need to match on 2 columns before pulling the
subsequent values in the row because values are repeated in the first column.
For example:

S_Codes Type Cost
123 A $100
123 B $50
124 A $75
124 B $40

So I need to create a lookup that will reference the Cost where s_code =
123 and type = 'A'. I appreciate any help on this!! Thanks!