Return all cells matching criteria

[jerichomurito]

Im totally new to vlookup and excel function..
Supposedly I have a spreadsheet like the one below, is it possible to check a certain string and return the value of all strings in that cell?
Let's say for example I want to search for all units/laptops that has "8GB" RAM and would return the display like these:

HP ProBook 450 G6 6FE36UT#ABA Laptop/i5-8265U/8GB/4TB 2.5 SATA SSD/15.6" Flat HD (1366x768)/Intel UHD 620/Windows 10 Pro
HP ProBook 450 G6 6FE36UT#ABA Laptop/i5-8265U/8GB/1TB 2.5 SATA SSD/15.6" Flat HD (1366x768)/Intel UHD 620/Windows 10 Pro
HP ProBook 450 G6 6FE36UT#ABA Laptop/i5-8265U/8GB/2TB 2.5 SATA SSD/15.6" Flat HD (1366x768)/Intel UHD 620/Windows 10 Pro
etc..

Please teach me how to do this..

https://docs.google.com/spreadsheets/d/1BHdyp4bx176gC4VfMb_B_2-zK3xPFBp9BvUhAXup5B4/edit?usp=sharing

 

[jerichomurito]

Well, I see
In the code provided the data supposed to be in column A
If Not, You will get the error you mentioned

WOW! it works!! Can i edit the code to further filter the results?

 

[Peter_SSs]

What exactly I would want is to return a value of all product or laptop description that has the same RAM memory for this instance i used 8GB as an example..
So all laptops with 8GB RAM memory in the spreadsheet would be displayed..

But that doesn't specifically answer the question below. Remember that you are familiar with your data and we are not.
- I could interpret the line below as having 16GB or 512 GB, or
- I could interpret as meaning everything from 16GB up to 512GB, including, say, 64GB, or
- It could mean something else altogether.
I am just trying to clarify.

To help clarify, what does this row tell us about the memory available?

HP ProBook 450 G6 6FE36UT#ABALaptop/i5-8265U/16GB/512GB M.2 PCIe SSD + 1TB 2.5 HDD/15.6" Flat HD (1366x768)/Intel UHD 620/Windows 10 Pro

 

[Peter_SSs]

WOW! it works!!

Are you sure?

For example, that code returns this (to me incorrect) line when I enter 8 in the input box.

HP ProBook 450 G6 6FE36UT#ABALaptop/i5-8265U/32GB/128GB M.2 PCIe SSD + 2TB 2.5 HDD/15.6" Flat HD (1366x768)/Intel UHD 620/Windows 10 Pro