Get some cells from row -> same items

[MESSIAHH]

I have table with many same name of items and types of items. How I can get only one cell from row where one cell have string "XXX"? There is many multiple items like:

id	name	age	color	number
1	xxx	32	red	100
2	yyy	35	green	80
3	yyy	35	green	80
4	xxx	32	red	100
5	yyy	35	green	80

So for example I need find item by name and display age or number or all 3 values.
Which one function will be the best?

[alansidman]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[MESSIAHH]

Sorry. Now I add file.

[alansidman]

On the Data Tab, click on Sort and Filter--->Advanced. Here is a picture of what you should do.

v	A	B	C	D	E	F	G	H	I	J	K
1	id	name	old	color	number			name	old	color	number
2	1	xxx	32	red	100			xxx	32	red	100
3	2	yyy	35	green	80			yyy	35	green	80
4	3	yyy	35	green	80
5	4	xxx	32	red	100
6	5	xxx	32	red	100

[MESSIAHH]

Sorry but I want find item by name from other file. How to find cell by name and display all entire row containing specific value name.

[AhsanQatar]

Hi,
I think "Vlookup" will help you.
find the attached.

If it's not satisfied you, upload your data sheet.
We can try another solution.