Lookup of Row (return data from specifide row) with collum heading and value.

Encryption algorythim.xlsx

Here is my scenario I have all this data i want to search in. In the rows there are repeating values and in the columns they do not repeat.
As seen in the attached i am able to give a column and row by title and then get the intersecting cell data from that. (Encryption lookup)
What i want to do is give the column tittle and row value and get back the row title. (Decryption Lookup)
This shouldn't be too hard seeing that the data in the columns has no repeats.
But i have tried multiple Google searches and plenty of screwing around and cant work this out.

Thanks.

Konastar

Give this a try... Click the button

Please Login or Register  to view this content.

Wow you guys are fast thanks ill give these a go

FDibbins got it in the bag man thank you guys so much.
Encryption has always been a hobby but this is my first grid like this.

Cant believe i didn't try this i probably did but couldn't get it to work.

Once again you guys are the best thanks so much.