vlookup to ignore a keyword

**vile10** · 04-25-2024, 11:40 PM

Hi all,

I am asking for help with my vlookup formula to pull result while ignoring a specific keyword

Scenario:

Part A is split across multiple storage locations, "space-0", "space-1", "space-2", etc.

I want the search result to exclude "space-0"

Thank you in advance

**wk9128** · 04-26-2024, 12:06 AM

Hi vile10 Welcome to the forum

Please read and refer to this link, how to upload attachments,follow mathod 2
https://www.excelforum.com/the-water...his-forum.html

Please add some manually calculated expected results
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

**vile10** · 04-26-2024, 09:25 PM

attached with sample file

I hope the result doesn't return with "space-0"

**wk9128** · 04-26-2024, 09:32 PM

Office 365 , Cell B2 formula

Formula:

Please Login or Register  to view this content.

other office version , Cell B2 formula , Drag down

Formula:

Please Login or Register  to view this content.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.