LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA Vlookup Tony Excel Discussion (Misc queries) 3 April 1st 09 09:37 PM
Excel Vlookup HELP [email protected] Excel Discussion (Misc queries) 3 September 4th 08 12:30 AM
VLOOKUP Conversion from Excel 2003 to Excel 2007 Michael D. Ober Excel Worksheet Functions 2 November 22nd 07 02:37 PM
Excel VBA Vlookup [email protected] Excel Programming 2 November 8th 06 01:23 AM
VBA excel + Forms : Vlookup on database by form / VBA excel +formulaire : rechercheV sur base de données viaformulaire Dick Kusleika[_2_] Excel Programming 0 October 16th 04 02:30 AM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"