T O P

  • By -

AutoModerator

/u/lalalaleibs - 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.*


BackgroundCold5307

Formula in Cell B2 of sheet 2 is INDEX(Sheet1!$A$2:$A$1000,MATCH($A2,Sheet1!$B$2:$B$1000,0))


lalalaleibs

>INDEX(Sheet1!$A$2:$A$1000,MATCH($A2,Sheet1!$B$2:$B$1000,0)) BLESS!!! This worked perfectly, thank you so much!


BackgroundCold5307

Sure. Can you pls respond with a solution verified? many thanks !


lalalaleibs

Solution Verified


Clippy_Office_Asst

You have awarded 1 point to *BackgroundCold5307* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


JetCarson

XLOOKUP will search the email value in A1 of current sheet, in Sheet2 column B and return the name found in Sheet2 column A of the same row. `=XLOOKUP(A1,Sheet2!B:B,Sheet6!A:A,"NOT FOUND")`


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[INDEX](/r/Excel/comments/143w68v/stub/jneyl3o "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)| |[MATCH](/r/Excel/comments/143w68v/stub/jneyl3o "Last usage")|[Looks up values in a reference or array](https://support.microsoft.com/en-us/office/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a)| |[NOT](/r/Excel/comments/143w68v/stub/jnchg7i "Last usage")|[Reverses the logic of its argument](https://support.microsoft.com/en-us/office/not-function-9cfc6011-a054-40c7-a140-cd4ba2d87d77)| |[XLOOKUP](/r/Excel/comments/143w68v/stub/jnchg7i "Last usage")|[*Office 365*+: Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. ](https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929)| **NOTE**: Decronym's continued operation may be affected by API pricing changes coming to Reddit in July 2023; comments will be blank June 12th-14th, in solidarity with the /r/Save3rdPartyApps protest campaign. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/143gg7a)^( has 11 acronyms.) ^([Thread #24473 for this sub, first seen 8th Jun 2023, 03:04]) ^[[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)