Match Multiple Values with Multiple Values from Another Table - Return a Single Value

**kibbles** · 05-12-2014, 05:42 PM

Good Afternoon All,
I am trying to look & match key values from 2 areas of one table with two areas of another table; in turn, it'd return one value based on the lookup table...

The attached worksheet can shed some light on what I'm trying to accomplish.

Is there a formula that'd work for this?

Any info would be IMMENSELY appreciated!

**ConneXionLost** · 05-12-2014, 06:02 PM

In cell C4 try this:

Please Login or Register  to view this content.

Autofill across/down as required.

Cheers,

**Miroslav R.** · 05-12-2014, 06:03 PM

Hi,

try this one:

Formula:

Please Login or Register  to view this content.

Test booklet.xlsx

Regards

M

**ConneXionLost** · 05-12-2014, 06:14 PM

Since you're using Excel 2003, try this to trap errors:

Please Login or Register  to view this content.

Cheers,

**Tony Valko** · 05-12-2014, 07:10 PM

Originally Posted by ConneXionLost

Since you're using Excel 2003, try this to trap errors...

Their profile says they're using Excel 2003 but the sample file they posted is in the *.xlsx format.

When an OP posts a file I craft my reply to the file format.

Match Multiple Values with Multiple Values from Another Table - Return a Single Value

LinkBack

Thread Tools

Rate This Thread

Display

Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Re: Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Re: Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Re: Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Re: Match Multiple Values with Multiple Values from Another Table - Return a Single Value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to return multiple values to a single cell based on multiple criteria

[SOLVED] Match multiple substrings in a cell against a lookup table and return concatenated values

[SOLVED] How to return multiple values that match a single search criteria?

[SOLVED] Use index to match two values where there are multiple values, return the highest

[SOLVED] Search multiple values to return single values

Bookmarks

Bookmarks

Posting Permissions