VLOOKUP with 2 Criteria

[Stacy_Sutton]

How can I perform a VLOOKUP with two criteria? I'm looking for one result but the result comes from a row with two matching pieces of data. I have a state abbreviation and a numeric county code and I want the formula to provide the result of the county name.

Data:
Column A: State
Column B: Numeric County Code
Column C: County Name

The formula needs to look at two variables on the same row, compare them to the data and then return the result of Column C.

Help please?

 

[asad]

Try this:

Excel Workbook
	A	B	C
31	State	County Code	Name
32	VIC	3000	Melbourne
33	NSW	4000	Sydney
34	TAS	5000	Hobart
35
36
37
38	NSW	4000	Sydney
Sheet1

Asad

 

[scottylad2]

THere's not much explanation of your layout and how your vlookup will be called, but this might give you a pointer

Excel Workbook
	A	B	C
1	State	Numeric	County
2	Arizona	100	County 1
3	Alaska	101	County 2
4	Alibama	102	County 3
5	New York	103	County 4
6	California	104	County 5
7
8	State	Numeric	County
9	New York	103	County 4
Sheet1

Couldnt use the Vlookup, hope this helps

Pipped by Asad

 

[Stacy_Sutton]

Thank you. I thought it was index and match but I haven't used those before. I will give this a try at work tomorrow. I appreciate your help!

 

[Stacy_Sutton]

Now I have to learn to use that awesome Excel Add-In for translating spreadsheets to HTML! LOL

I got the formula to work!! Thank you so much for your help!!

Stacy