| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Appropriate formula needed!
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 cant seam to work it out. I already have numbers per category in sheet2 i.e: Sheet1 has the following Category Assigned Nr. Cat1 100 (thsi shoudl be the result of the formula) Cat1 100 ----- | | ----- Cat1 100 ----- | | ----- .. .. .. Cat2 300 Cat2 300 .. .. .. Sheet2 has this: Category Assigned Nr. Cat1 100 Cat2 300 Cat3 700 Thank you, Adnan -- Please post all your inquiries on this community so we can all benefit - Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Appropriate formula needed!
Assume the lookup table is in range A1:B10, the category number is in column
B, and your lookup value is in A20: =VLOOKUP(A20,A1:B10,2,FALSE) Copy down as needed. You wil, of course, have to change the cell references to suit your particular spreadsheet, but that's the syntax you're looking for. If it doesn't work, post the formula you're using. Dave -- Brevity is the soul of wit. "Adnan" wrote: 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 cant seam to work it out. I already have numbers per category in sheet2 i.e: Sheet1 has the following Category Assigned Nr. Cat1 100 (thsi shoudl be the result of the formula) Cat1 100 ----- | | ----- Cat1 100 ----- | | ----- . . . Cat2 300 Cat2 300 . . . Sheet2 has this: Category Assigned Nr. Cat1 100 Cat2 300 Cat3 700 Thank you, Adnan -- Please post all your inquiries on this community so we can all benefit - Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Appropriate formula needed!
Thank you Dave! It worked.
v/r Adnan -- Please post all your inquiries on this community so we can all benefit - Thank you! "Dave F" wrote: Assume the lookup table is in range A1:B10, the category number is in column B, and your lookup value is in A20: =VLOOKUP(A20,A1:B10,2,FALSE) Copy down as needed. You wil, of course, have to change the cell references to suit your particular spreadsheet, but that's the syntax you're looking for. If it doesn't work, post the formula you're using. Dave -- Brevity is the soul of wit. "Adnan" wrote: 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 cant seam to work it out. I already have numbers per category in sheet2 i.e: Sheet1 has the following Category Assigned Nr. Cat1 100 (thsi shoudl be the result of the formula) Cat1 100 ----- | | ----- Cat1 100 ----- | | ----- . . . Cat2 300 Cat2 300 . . . Sheet2 has this: Category Assigned Nr. Cat1 100 Cat2 300 Cat3 700 Thank you, Adnan -- Please post all your inquiries on this community so we can all benefit - Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| IF-THEN Formula help needed | Excel Worksheet Functions | |||
| Formula needed | Excel Worksheet Functions | |||
| continuous sum formula needed | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
