Really Dumb Open Office Question

[Khayembii Communique]

Basically what I'm trying to do is that I have a list of items (numbered 1 to 50) in Sheet 1. Each of these items has 3-4 columns of information, with the first column being the reference number.

Ref No. Column B Column C Column D
1 "info" "info" "info"
2 "info" "info" "info"
3 "info" "info" "info"

On sheet 2, I am trying to have Column A be an input for the reference number, and then columns B, C and D return the outputs in the same columns on the first sheet. In other words, you input the reference number in Column A on Sheet 2, and then in columns B-D on that same sheet it gives you the information for that reference number listed on Sheet 1.

Now I could do it with an If/Then statement, but considering that I have 50 reference numbers that would get really messy really quick. Isn't there an easier way to do this? There has to be something I'm missing.

I tried setting the output for Column B on Sheet 2 to:

=Sheet1.D(A2)

(A2 is the cell on that sheet where you would input the reference number). In other words, have the output cell's row number be directly conditional to the reference number, which seems easiest, but obviously the code I put in wasn't the correct terminology, or it's not possible at all.

I hope this makes sense, it's simple in concept but I'm having trouble explaining it. Anyone have any ideas?

EDIT: Basically I'm using Sheet 1 as a database and sheet 2 to access it and return the information for a given reference number listed in the database.

 

[Khayembii Communique]

NVM figured it out. Just had to use the =LOOKUP() function.

 

[Khayembii Communique]

**** nevermind that totally didn't work, it's still the same problem just now it's in the LOOKUP function WTFFFFF

 

[Jr Mouse]

5 star thread.

 

[Khayembii Communique]

Bahaha ignore this thread I love you too.

I figured it out. I'm awesome

 

[ginlimetonic]

Ref No. Column B Column C Column D
1 "info" "info" "info"
2 "info" "info" "info"
3 "info" "info" "info"

=VLOOKUP(cell to lookup,$table$reference, column to lookup,FALSE)

i.e. for Col B,

=VLOOKUP(B1,$B$2:$D$4,2,false)

col c

=VLOOKUP(B1,$B$2:$D$4,3,false)

col d

=VLOOKUP(B1,$B$2:$D$4,4,false)

you can be tricky and embed functions within vlookup formula,

VLOOKUP(b1,defined range table, MATCH(header title, column headers, 0),false)