| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use vlookup in this case
Hello Guys,
On one sheet a have a data base. Exempl. A (name - code) B (value) 1 4562 120,00 2 4598 698,00 3 5987 860,00 4 6987 987,00 On the other sheet I have to write some sum's from the previous sheet. total sales from region Europe = (4598 + 6987- code)=698,00+987,00 the problem is that the rows with codes are not on the same place all the time. They can be aded multiple rows with other codes. Becouse of that I was thinking to use VLOOKUP to find proper codes which they belong together and sum it. Can somebody give me a tip. Regards Mitja -- mj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set up vlookup so that it is case sensitive? | Excel Discussion (Misc queries) | |||
| How do I use case sensitive VLOOKUP? | Excel Worksheet Functions | |||
| vlookup -- Upper case and Lower case text | Excel Discussion (Misc queries) | |||
| VLookup & Case Sensitivity | Excel Worksheet Functions | |||
| Case sensitive vlookup | Excel Discussion (Misc queries) | |||
Threaded Mode
