Vlookup question

[lynx1971]

Hi,

I have three columns in a worksheet as under

120 1760ABCD12 6062100000
130 1760ABCD13 6062100001
140 1760ABCD14 6062100002
150 1760ABCD15 6062100003
160 1760ABCD16 6062100004

On the lower half of the worksheet, I have an area where I would like to just type in the codes from the first column and then have the data in the 2nd and 3rd columns appear one below the other after the first code like this:

120
1760ABCD12
6062100000


How would I do this? I think it uses the IF, VLOOKUP and ISERROR functions, but I can't remember how.

Thanks in advance,

Lynx

 

[JamesW]

For the first code:

=VLOOKUP(C1,A1:C5,2,FALSE)

For the second code:

=VLOOKUP(C1,A1:C5,3,FALSE)

Where C1 is the code you type in (120), A1:A5 is the table of data and 2/3 is the column index.

 

[VoG]

Try like this

Excel Workbook
	A	B	C
1	120	1760ABCD12	6062100000
2	130	1760ABCD13	6062100001
3	140	1760ABCD14	6062100002
4	150	1760ABCD15	6062100003
5	160	1760ABCD16	6062100004
6
7	120
8	1760ABCD12
9	6062100000
Sheet3

 

[lynx1971]

SOLVED Re: Vlookup question

Hi there, JamesW and VoG!

Thank you very much for your replies. They helped immensly!!!

Cheers,

Lynx