Vlookup into 2 columns

[Irina]

Can a Vlookup look into 2 columns for reference and then return the number?
I have a list with 3 fields from which I need to pull out the 3rd field, if the first 2 columns contain the right data. What is the best way to do that?
Ex:
State County Code
NY Essex 31
NJ Essex 13

So if State=NY and County=Essex, return 31, if state=NJ and county=Essex, return 13.
There are lots of rows, but the point is that County & State need to be looked up for the correct code to be returned.

Please help.
Thank you

Submitted via EggHeadCafe
ASP.NET Base64 Image Encoding via the Data: protocol
http://www.eggheadcafe.com/tutorial...e64-image-encoding-via-the-data-protocol.aspx

 

[Pete]

Irina:
You could use SUMIFS if there is only one numerical value for each
combination of state and county..
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2,
criteria2], ...)
(Sum_range, in your case would be the code column.)
Available in Excel 2007 and later.

If you have 2003 or before, SUMPRODUCT funcion would be the way to
go. That would also work with later versions.

Do report back.

Pete

 

[Irina]

Thank you for your reply.

I was overthinking the problem.I can use the FIPS codes which are unique county+state to identify each line and then I'll vlookup to get the right data.

Thanks
Irina


Submitted via EggHeadCafe
Install Windows Updates using C# & WUAPI
http://www.eggheadcafe.com/tutorial...b/install-windows-updates-using-c--wuapi.aspx