Baby steps.....
 

I have had no training whatsoever in Excel. What very little I know I
have picked up by using existing worksheets. Unfortunatly I don't have
a lot of time to spend learning the system right now.
To put it short....I'm inexperienced and inept. :)

I have several sheets I have created to manage a vehicle inventory.
Currently, they are not tied together in any way. So, if I have to
make a change to one, I have to change them all.

I think what I need probably has a simple solution, but I haven't been
able to figure out what I even need to ask or look for to find the
solution.

In short, I need to link a truck number to a route number on a master
sheet.
I then need to be able to type the route number on another sheet and
have the truck number appear in the adjoining box. Sounds
simple...I'm sure it probably is.

Thought one of the experts here could throw an old dog a bone... ;)


--
cpegram
------------------------------------------------------------------------
cpegram's Profile: http://www.excelforum.com/member.php...o&userid=24046
View this thread: http://www.excelforum.com/showthread...hreadid=376568

Hi cpegram,

try this in new excel spreasheets 1 & 2 (As a test)

Spreadsheet 1

A1 truck Numbers

A2 to A7 Enter random truck numbers

B1 Route Numbers

B2 to B7 Enter random route numbers

Sreadsheet 2

A1 Truck Numbers

A2 to A7 Enter Your list of random truck numbers

B1 Route Numbers

B2 Enter this and drag down to B7


Code:
--------------------


=IF(ISNA(VLOOKUP(A2,Sheet1!$A$2:Sheet1!$B$7,2,FALS E)),"0",VLOOKUP(A2,Sheet1!$A$2:Sheet1!$B$7,2,FALSE ))


--------------------



Will this help?


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=376568

B2 Enter this and drag down to B7

After I enter the formula how do I drag it down to B7....when I type it
in B3 I get the value for B2

Like I said...I don't know much :)


--
cpegram
------------------------------------------------------------------------
cpegram's Profile: http://www.excelforum.com/member.php...o&userid=24046
View this thread: http://www.excelforum.com/showthread...hreadid=376568

In sheet 2 single click cell B2 You will see a little black box in the
lower right corner of that cell left click holding the mouse and drag
down to B7


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=376568

Wow. :)

The internet is a wonderful thing.
Thanks for the help.


--
cpegram
------------------------------------------------------------------------
cpegram's Profile: http://www.excelforum.com/member.php...o&userid=24046
View this thread: http://www.excelforum.com/showthread...hreadid=376568

Glad to help.


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=376568