Excel Lookup with Two Criteria

[DeLaMartre]

I have a large table consisting of six fields. I want to use a Lookup function (similar to VLOOKUP), but it needs to be based on the contents of the first two fields, rather than just the first field as in VLOOKUP.

Any suggestions? I would prefer not to use VBA (because of my moderate ignorance in that area), but will be grateful for any solution.

Thanks very much, -Bob in California

 

[DaleWatson123321]

Hi Bob,

Great to see you're still "soakin' up the sun" in California

I'd love to help out. As you know, it's my usual request that I work with the actual file (or with sensitive data replaced with fictitious data if required) - as it makes it much easier at both ends.

I'm still at my usual place.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DeLaMartre]

Hello Dale, my friend,

As always, I very much appreciate your kind offer to help.

I have been (truly) meaning to write to you, but have been remiss in my correspondence. I hope all is well with you and your family in the Great North Land.

As it so happens, I worked on this problem in my head on my long commute home tonight and figured it out. I inserted a new column/field into the database and concatenated the first two fields to make a "key". The "key" was then used to make my vlookup tool.

It is a simple-minded solution, but that suits me best (Ha!).

All the Best, -Bob in California

 

[weetnie]

Hi,

You could try combining the two columns

eg vlookup((A1&b1),'sheet2C,2,false) Where C is a combined lookup table

If this does not work could you give an example of the lookup result?