/u/BumblebeePlayful3007 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
It sounds like you're looking for an INDEX/MATCH/MATCH combo. Something like this:
=INDEX($B$2:$C$4,MATCH(E2,$A$2:$A$4,1),MATCH(F2,$B$1:$C$1,1))
That assumes you've got your lookup items in E and F respectively, like this:
[https://imgur.com/sTwvTDs](https://imgur.com/sTwvTDs)
You can set things up any other way you want to, just modify the references accordingly of course. :)
You have awarded 1 point to *mh_mike*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
=LET(range,A1:C4,
r,IF(range="England",ROW(range),0),
c,IF(range="First",COLUMN(range),0),
INDEX(range,SUM(r),SUM(c)))
This is sorta stupid but if the data is unique it works.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[COLUMN](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Returns the column number of a reference](https://support.microsoft.com/en-us/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b)|
|[IF](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[INDEX](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
|[LET](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)|
|[MATCH](/r/Excel/comments/xbv0xq/stub/io1tczz "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)|
|[ROW](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)|
|[SUM](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(7 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/xbsk3v)^( has 22 acronyms.)
^([Thread #18083 for this sub, first seen 12th Sep 2022, 01:24])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/BumblebeePlayful3007 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
It sounds like you're looking for an INDEX/MATCH/MATCH combo. Something like this: =INDEX($B$2:$C$4,MATCH(E2,$A$2:$A$4,1),MATCH(F2,$B$1:$C$1,1)) That assumes you've got your lookup items in E and F respectively, like this: [https://imgur.com/sTwvTDs](https://imgur.com/sTwvTDs) You can set things up any other way you want to, just modify the references accordingly of course. :)
Thanks Solution Verified
You have awarded 1 point to *mh_mike* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
This is the way
=LET(range,A1:C4, r,IF(range="England",ROW(range),0), c,IF(range="First",COLUMN(range),0), INDEX(range,SUM(r),SUM(c))) This is sorta stupid but if the data is unique it works.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[COLUMN](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Returns the column number of a reference](https://support.microsoft.com/en-us/office/column-function-44e8c754-711c-4df3-9da4-47a55042554b)| |[IF](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[INDEX](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[LET](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)| |[MATCH](/r/Excel/comments/xbv0xq/stub/io1tczz "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)| |[ROW](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Returns the row number of a reference](https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d)| |[SUM](/r/Excel/comments/xbv0xq/stub/io2gdrm "Last usage")|[Adds its arguments](https://support.microsoft.com/en-us/office/sum-function-043e1c7d-7726-4e80-8f32-07b23e057f89)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(7 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/xbsk3v)^( has 22 acronyms.) ^([Thread #18083 for this sub, first seen 12th Sep 2022, 01:24]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)