Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 3rd 04, 09:45 PM
CLSCHWIES
 
Posts: n/a
Default Vlookup and Indexing in excel

Here's the problem
SFSD=Location
DEN=LOCATION

5203
0
0
0
0
Adj total =50.00


5204
0
0
0
0
Adj total =50.00

5206

9124



table = 5203, 5204
chairs = 5204, 5206
couch
bed
dresser

I want to get the total of table adjust for SFSD and other locations
tHEN TAKE THAT RESULT TIMES ANOTHER NUMBER
Can you help me

  #2   Report Post  
Old December 3rd 04, 10:44 PM
Frank Kabel
 
Posts: n/a
Default

Hi
several thinsg not clear:
- your real data layout
- what you're trying to achieve

--
Regards
Frank Kabel
Frankfurt, Germany

"CLSCHWIES" schrieb im
Newsbeitrag news
Here's the problem
SFSD=Location
DEN=LOCATION

5203
0
0
0
0
Adj total =50.00


5204
0
0
0
0
Adj total =50.00

5206

9124



table = 5203, 5204
chairs = 5204, 5206
couch
bed
dresser

I want to get the total of table adjust for SFSD and other locations
tHEN TAKE THAT RESULT TIMES ANOTHER NUMBER
Can you help me


  #3   Report Post  
Old December 4th 04, 01:57 AM
CLSCHWIES
 
Posts: n/a
Default

LANC 0
0 0
Tons 0
Income per Ton 0
5124 0
Tons 0
Income per Ton 0
5127 0
Tons 0
Income per Ton 0
5143 0
OCGS -261
Adj Cash Income -261
Tons 0
Income per Ton 0
Total IOIC -261
5152 0
Tons 0
Income per Ton 0
5153 0
Tons 0
Income per Ton 0
5162 0
Tons 0
Income per Ton 0
5163 0
Cash IOIC -281
OCGS -770
Adj Cash Income -1051
Tons 0
Income per Ton 0
Total IOIC -1051
5170 0
Tons 0
Income per Ton 0
5181 0
Tons 0
Income per Ton 0
5183 0
OCGS 100
Adj Cash Income 100
Tons 0
Income per Ton 0
Total IOIC 100
5186 0
Tons 0
Income per Ton 0
5187 0
Tons 0
Income per Ton 0
5191 0
Tons 0
Income per Ton 0
5193 0
Tons 0
Income per Ton 0
5195 0
Tons 0
Income per Ton 0
5196 0
OCGS 22577
Adj Cash Income 22577
Tons 0
Income per Ton 0
Total IOIC 22577
5198 0
Tons 0
Income per Ton 0
5202 0
OCGS -115
Adj Cash Income -115
Tons 0
Income per Ton 0
Total IOIC -115
5205 0
Tons 0
Income per Ton 0
5209 0
Tons 0
Income per Ton 0
5215 0
Tons 0
Income per Ton 0
5221 0
Tons 0
Income per Ton 0
5227 0
Tons 0
Income per Ton 0
5230 0
Tons 0
Income per Ton 0
5234 0
Cash IOIC 0
Adj Cash Income 0
Tons 0
Income per Ton 0
Other OCGS 1407
Total IOIC 1407
5236 0
Tons 0
Income per Ton 0
Other OCGS 0
Total IOIC 0
5244 0
Tons 0
Income per Ton 0
5267 0
Cash IOIC 4746
OCGS 92
Adj Cash Income 4838
Tons 0
Income per Ton 0
Other OCGS 669
Total IOIC 5507
5278 0
Tons 0
Income per Ton 0
5286 0
OCGS -595
Adj Cash Income -595
Tons 0
Income per Ton 0
Total IOIC -595
5289 0
Tons 0
Income per Ton 0
5292 0
Tons 0
Income per Ton 0
5294 0
Tons 0
Income per Ton 0
5299 0
OCGS -84186
Adj Cash Income -84186
Tons 0
Income per Ton 0
Other OCGS 61609
Total IOIC -22577
5302 0
Tons 0
Income per Ton 0
6499 0
Tons 0
Income per Ton 0
9124 0
Cash IOIC -189098
OCGS 19846
BC 5153
EVAN 5163
FRAN 5202
LAB 9163
LANS 5183
LDC 5305
LIMA 9183
LOOG 5170
MASS 5181
MILF 9181
ORRV 5143
RIDC 5294
WCH 9143
ZEEL 9294
8X 5124
DIR 9124
RCHM 5114
RITD 5302
ABDN 5399
CAIN 9399
CLAR 5191
COL 9191
DL 5195
FOND 5230
FREM 9195
FRON 9230
FRTB 5198
GOTH 9198
GRIN 5187
HURN 9187
IGH 5499
KANS 9499
LC 5205
LINE 5215
MARN 5234
MAUS 5267
MAXT 9215
MC 9234
MONT 9267
MUNC 0000
NASH 5196
NUTR 5299
OWAT 9196
SCIA 9299
SFSD 6499
SHEL 5152
SHGL 9152
SPEN 5221
STJN 9221
STJO 5289
VAND 9289
WIL 5244
6A 9289
6B 5244
6C 9244
6D 5209
6E 9244
6H 5209
6I 9209
7A 6671
7B 6672
7C 6673


Table
Chair
Tablechair
etc
etc

I have several locations
The numbers refer to certain items
such as Table is each to 5124, 5127 and etc
I need to find the location and at each location need to find what numbers
equal table
And those numbers find the adj cash
So 5124 and 5127 both refer to the item table and that adj
cash income is -261.00
items 5152, 5153, 5162 would refer to chair
those numbers adj cash income is -1051.00
you might have 5127 amd 5152 which would be tablechair which would be -261.00
and -1051
So this would be location LANC and my answer for table would -261.00
Chair would be 5152, 5153, 5162, and the answer would be -1051.00
Tablechair would be item 5127, 5152 and the answer would be
(1051.00)+(-261.00)

Than I need to take those results for each table, chair and tablechair and
multiple that number by a different number






"Frank Kabel" wrote:

Hi
several thinsg not clear:
- your real data layout
- what you're trying to achieve

--
Regards
Frank Kabel
Frankfurt, Germany

"CLSCHWIES" schrieb im
Newsbeitrag news
Here's the problem
SFSD=Location
DEN=LOCATION

5203
0
0
0
0
Adj total =50.00


5204
0
0
0
0
Adj total =50.00

5206

9124



table = 5203, 5204
chairs = 5204, 5206
couch
bed
dresser

I want to get the total of table adjust for SFSD and other locations
tHEN TAKE THAT RESULT TIMES ANOTHER NUMBER
Can you help me





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vlookup - indexing Josef.angel Excel Worksheet Functions 7 October 29th 04 08:50 AM


All times are GMT +1. The time now is 12:36 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017