[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
rhodestransit
Power User

Joined: 17 Mar 2011
Posts: 91

 Posted: Mon Feb 13, 2012 11:06 am    Post subject: (SOLVED) Lookup Never used a lookup before, been looking at some help topics and still cant work it out, What i need to do is this INPUT sheet will have a number input say A1 RUNDATA sheet has a column with numbers A1:A73, LP1:LP8 and a whole host of others the B column on RUNDATA has a number in it If i enter A1 onto my INPUT sheet i need it to match that number on the RUNDATA sheet (it will be cell A2) and return the number in the cell B2. I have about 300 bus runs that each are a different length of time and I want to input the route number and have the length of time returned.Last edited by rhodestransit on Fri Feb 17, 2012 5:37 am; edited 1 time in total
JohnV

Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

 Posted: Mon Feb 13, 2012 12:13 pm    Post subject: Assuming the number you want to look up is in cell A1 of the INPUT sheet in B1 enter =VLOOKUP(A1;RUNDATA.A1:B73;2;0)
rhodestransit
Power User

Joined: 17 Mar 2011
Posts: 91

Posted: Mon Feb 13, 2012 12:26 pm    Post subject:

 JohnV wrote: Assuming the number you want to look up is in cell A1 of the INPUT sheet in B1 enter =VLOOKUP(A1;RUNDATA.A1:B73;2;0)

I am entering the run into column D of the INPUT sheet the runs are listed on column A of the INPUT sheet and the number i need it to return is in column B of the RUNDATA sheet
I modified the formula to work,
Thanks for the help.
JohnV

Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

 Posted: Mon Feb 13, 2012 2:47 pm    Post subject: =VLOOKUP(A1;RUNDATA.A1:B73;2;0) Change the 1st A1 above to the name of the cell containing what you want looked up. This formula can go into any empty cell in INPUT sheet.
rhodestransit
Power User

Joined: 17 Mar 2011
Posts: 91

 Posted: Fri Feb 17, 2012 5:36 am    Post subject: That worked, Thanks for the help.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum