Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel VBA Vlookup | Excel Discussion (Misc queries) | |||
Excel Vlookup HELP | Excel Discussion (Misc queries) | |||
VLOOKUP Conversion from Excel 2003 to Excel 2007 | Excel Worksheet Functions | |||
Excel VBA Vlookup | Excel Programming | |||
VBA excel + Forms : Vlookup on database by form / VBA excel +formulaire : rechercheV sur base de données viaformulaire | Excel Programming |