Yes what wanna do is be able to scan in information such as a modems Mac and
s/n off a box, and a serial number off a trial, they all 3 have bar codes I'd
like feel if I could to recognize whats what and put it in the right column.
------Original Message------
From: xmdp <mper...@gmail.com>
To: <A-1-Computer_Tech@yahoogroups.com>
Date: Friday, May 24, 2013 8:46:10 PM GMT-0400
Subject: Re: [A-1-Computer_Tech] info/advice needed
This is pretty easy if you know Lookup function in Excel. It's only
slightly harder if you don't. Lookup tables are fairly easy to set up and
use.
I'll make some assumptions on a possible solution to your scan-in and get
info-back.
Scan the barcode into A1.
Elsewhere on the Excel sheet you have a data base (table if you will) where
all the barcode numbers of the items are listed, lets say column F.
In columns G, H, I, J, K are five items (you can have more if needed) of
info that relate to the barcode in F. (Name, Description, Model,,
whatever...)
In the cells where you want to return that info you can use a VLOOKUP
formula that will look something like this:
=VLOOKUP(A1,$F$1:$K$50,{2,3,4,5,6},0)
Broken down it means:
=VLOOKUP( - calls the VLOOKUP function
A1 is the cell containing the barcode you scanned in
$F$1 is the top left cell of the lookup table containing your data
$k$50 is the bottom right cell of the lookup table containing your data
2,3,4,5,6 represent the second, third, fourth, fifth and sixth colu,mn of
the lookup table
the zero at the end forces a #N/A value to be returned. That will flag you
that no data exists and you will have to either verify the barcode or add
data to your lookup table.
So the formula will take the value in A1 and look for it in column F and
when a match is noted, returns the information in columns G, H, I, J, K.
Is this some what like what you are after?
On Fri, May 24, 2013 at 6:54 PM, james b <jjamescbar...@yahoo.com> wrote:
> **
>
>
> ok guys here is my situation, i am working for a company that installs
> exede, and i have to do a inventory of all my equipment that i have at my
> house once a week, it all has bar codes and then has the information on it,
> my question is could, can i get a barcode scanner, scan all this in and put
> it into a exel doc. and make it easyier to do for me, because i have 12 to
> 20 units a week and it gets to be a pain to punch it all in.
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
If you have any questions or problems with any aspect of this site, please feel
free to contact me directly bi...@optonline.net Please do not post personal
issues directly to the group.
To unsubscribe from this list, send an email to
a-1-computer_tech-unsubscr...@yahoogroups.com
Thank you for using A-1 Computer TechYahoo! Groups Links
------------------------------------
If you have any questions or problems with any aspect of this site, please feel
free to contact me directly bi...@optonline.net Please do not post personal
issues directly to the group.
To unsubscribe from this list, send an email to
a-1-computer_tech-unsubscr...@yahoogroups.com
Thank you for using A-1 Computer TechYahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/A-1-Computer_Tech/join
(Yahoo! ID required)
<*> To change settings via email:
a-1-computer_tech-dig...@yahoogroups.com
a-1-computer_tech-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
a-1-computer_tech-unsubscr...@yahoogroups.com
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
