| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8982
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) |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8982
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. |
|
| Back to top |
|
|
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. |
|
| Back to top |
|
|
|
