Home 
Search 
Today's Posts 
#1




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




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




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 
Display Modes  


Similar Threads  
Thread  Forum  
Vlookup  indexing  Excel Worksheet Functions 