Pulling Data from Table

[TBone32]

I'm trying to figure out how to pull data from a table such as below. I would like to be able to search for a value, such as 4 and receive the other 3 values in the same line. Such as search for 4 and the result would be 9, 20 & 23. Thanks!

1	12	8	6
2	22	10	5
9	20	4	23
13	7	3	21
11	24	14	19
15	18	16	17

<tbody>
</tbody>

 

[Legacy 436357]

Hi,

I set up some data to show you how to import by using one reference number. In sheet one is the raw data. In sheet 2 if you enter the ID number the rest fills in with this index match array.

I hope this helps you to understand one way to fill the row with the other data.

Best regards,
XJ

Excel Workbook
	A	B	C	D
1	Data Imported From Sheet 1
2	ID	Data1	Data2	Data3
3	1	red	car	01/01/2019
4	2	blue	house	01/22/2019
5	3	green	wagon	01/25/2019
6	4	yellow	bicycle	12/25/2018
7	5	brown	scooter	11/22/2017
Sheet2

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1086843-pulling-data-table.html#post5222891

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
I have closed this thread as you have a solution in the other one.