• I'm happy to introduce the Styleforum Happy Hour, our brand new podcast featuring lively discussion about menswear and the fashion industry. In the inaugural edition, a discussion of what's going on in retail today. Please check it out on the Journal. All episodes will be also be available soon on your favorite podcast platform.

  • STYLE. COMMUNITY. GREAT CLOTHING.

    Bored of counting likes on social networks? At Styleforum, you’ll find rousing discussions that go beyond strings of emojis.

    Click Here to join Styleforum's thousands of style enthusiasts today!

Really Dumb Open Office Question

Khayembii Communique

Distinguished Member
Joined
Apr 4, 2010
Messages
2,440
Reaction score
336
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

Distinguished Member
Joined
Apr 4, 2010
Messages
2,440
Reaction score
336
Shit nevermind that totally didn't work, it's still the same problem just now it's in the LOOKUP function WTFFFFF
 

Jr Mouse

Stylish Dinosaur
Dubiously Honored
Joined
Nov 18, 2009
Messages
20,728
Reaction score
5,944
5 star thread.
 

ginlimetonic

Senior Member
Joined
Mar 11, 2009
Messages
786
Reaction score
1
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)
 

Featured Sponsor

How many pairs of shoes do you own?

  • 1 - 4

    Votes: 16 3.3%
  • 5 - 10

    Votes: 81 16.8%
  • 11 - 20

    Votes: 159 33.0%
  • 21 - 30

    Votes: 79 16.4%
  • 31 - 40

    Votes: 41 8.5%
  • 41 - 50

    Votes: 30 6.2%
  • 51 - 60

    Votes: 18 3.7%
  • 61 - 70

    Votes: 9 1.9%
  • 71 - 80

    Votes: 13 2.7%
  • 81 - 90

    Votes: 4 0.8%
  • 91 - 100

    Votes: 4 0.8%
  • 100+

    Votes: 28 5.8%

Related Threads

Forum statistics

Threads
427,582
Messages
9,201,131
Members
193,201
Latest member
tyheuhhrow

Styleforum is proudly sponsored by

Top