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,,,,,
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,,,,,
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
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
What determines the value returned in Column G, since there may be two different results? Row 4-9027 and Row 8-6737?
Thanks Alot XOR LX Perfect Formula.... Amazing Works Solved
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks