Appropriate formula

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

Guest

I have a spread sheet with 24000 records, and these records are divided by
category (each category has over 1000 records).
My question is, I need to assign a number per category, I tried Vlookup but
can’t seam to work it out.
I already have numbers per category in sheet2

i.e:
Sheet1 has the following
Category Assigned Nr.
Cat1 100
Cat1 100
Cat1 100
..
..
..
Cat2 300
Cat2 300
..
..
..

Sheet2 has this:
Category Assigned Nr.
Cat1 100
Cat2 300
Cat3 700



Thank you,
Adnan
 
Adnan said:
I have a spread sheet with 24000 records,

Sorry. This is a newsgroup dedicated to questions about Access, the
database program in Office Professional. It appears your question may not
be related to these subjects. The Microsoft help system is not all that
clear and may have misdirected you here.

It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
http://tc2.atspace.com/0013-HowToSearch.htm#FindNewsgroup may help.


Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.
 
Back
Top