Dragging Data into a new worksheet and arranging it by type

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This might be confusing, but any help would be great. I would like to paste a
series of values into a cell and have a coresponding name appear next to it.
For example, if I paste "00-0000-00" into A1 I want excel to assiociate
"00-0000-00" as a "belt" in B1. If I enter "00-0000-01", I would want it to
assiciate it with "knife" and so on. I think using acess would be better for
this application, but I am clueless as to how to use acess. Thanks for your
help.
 
You need to create a VLOOKUP table or use VBA
Look up VLOOKUP in help
 
Thanks for the help. No I am having a problem with copying data from another
excell file. I highlight and copy data from one file, and then paste it where
I have my vlookup formula, but I don't get any results.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access General Date Forced To Have Date And Time 2
IF calculation of Time 2
Formula to add two spaces into a number stored as text 3
Time Sum in Excel 1
converting text into years 4
Convert data into proper time format 1
dragging a series of data and incrementing the values 1
Need to work out a timesheet with times going into next day (>24 h 5

Back
Top