index and match function result from three way look up

**johnodys** · 11-14-2013, 12:34 PM

dear expert

i need excel formula to get result from three way lookup ( first two column and one multiple row value)

set of table lookup thorugh three way criteria get result of months below ,

find the attachment

you may understand easily,,,,,

**XOR LX** · 11-14-2013, 12:36 PM

Hi,

=INDEX($C$2:$I$9,MATCH(C14&D14,INDEX($A$2:$A$9&$B$2:$B$9,,),0),MATCH(G14,$C$1:$I$1,0))

Regards

**Chris 53** · 11-14-2013, 12:40 PM

Put a helper column to the left of your table, insert column A

Concatenate Region and Parts. So in A2 formula would be =B2&C2

Get the result with the vlookup formula =VLOOKUP(D14&E14,A2:J9,MATCH(H14,B1:J1)+1,FALSE)

Hope this helps

Chris

**JOHN H. DAVIS** · 11-14-2013, 12:51 PM

What determines the value returned in Column G, since there may be two different results? Row 4-9027 and Row 8-6737?

**johnodys** · 11-15-2013, 01:39 AM

Thanks Alot XOR LX Perfect Formula.... Amazing Works Solved

**XOR LX** · 11-15-2013, 03:32 AM

You're welcome.

index and match function result from three way look up

LinkBack

Thread Tools

Rate This Thread

Display

index and match function result from three way look up

Re: index and match function result from three way look up

Re: index and match function result from three way look up

Re: index and match function result from three way look up

Re: index and match function result from three way look up

Re: index and match function result from three way look up

Thread Information

Users Browsing this Thread

Similar Threads

index match, ..... skip result if blank value ...... jump to next match

[SOLVED] INDEX MATCH function returns result #N/A

[SOLVED] Index Match if result is not something

index match result issue

Index and match function using two values to return result

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions