Hello everyone!
I have this table:
Attachment 636234
**********321------206------207------210------213------214------215------329------216------222***
321---AA---311---------------------------------------------------1--------------------1
206---BB--------------345-----------------------------2-----------------------------------------5
207---CC--------------------------188----------------11-------------------------------2
210---DD---1----------2-------------------397------------------------------1------------------10
213---EE----------------------------------------------157---------------------------------------------------3
214---FF--10----------------------------------------------------227-------------------2--------------------4
215---GG---------------1-------------------7----------1-------------------256--------2--------17---------3
329---HH------------------------------------------------------------------------------254
219---II-----------------3------------------3------------------------------1--------------------193----
222---JJ------------------------------------------------------------3------------------------------1--------236
I am trying to get the row and column values based on a given name from column 1 and 2, like this:
Name: BB (finds row values)
Loc: 206 (finds column values)
Expected Result:
**206------213------2016**
345------2 ------ 5
2
1
3
So far I got this formula: INDEX($D$14:$M$14,,MATCH(D23,INDEX($D$15:$M$21,MATCH($C$23,$B$15:$B$21,0),),0))
but it does not work when same numbers are in the row.
Please I need your help, your knowledge.
Thanks
Bookmarks