How to gather data from next cell over

[dmb41]

I have a large table of data and I am looking to extract what is next the data out of the table.

I have something like the following:

A B C D
101 BLD WA A2
105 BLD WA B5
115 BLD WA C2
125 BLD WA G5

And I am looking to get this from the data:

101 A2
115 B5
105 C2

Basically what ever I type (101, 115, etc) I am looking to retrieve what ever is next to it in column D.

I have tried this function but I am missing something:
=IF(MATCH($A2,$A$10:$A$151216,0),$D10,0)

Any direction would be appreciated.

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D	E	F
1	101	BLD	WA	A2	101	A2
2	105	BLD	WA	B5
3	115	BLD	WA	C2
4	125	BLD	WA	G5
Sheet2

 

[T. Valko]

I have a large table of data and I am looking to extract what is next the data out of the table.

I have something like the following:

A B C D
101 BLD WA A2
105 BLD WA B5
115 BLD WA C2
125 BLD WA G5

And I am looking to get this from the data:

101 A2
115 B5
105 C2

Basically what ever I type (101, 115, etc) I am looking to retrieve what ever is next to it in column D.

I have tried this function but I am missing something:
=IF(MATCH($A2,$A$10:$A$151216,0),$D10,0)

Any direction would be appreciated.

One way...

=INDEX($D$10:$D$151216,MATCH($A2,$A$10:$A$151216,0))

 

[dmb41]

Thanks. Exactly what I was looking for. Should be easy to expand to the large table of data I have, also.