Hello everyone,
I've been reading for about 20 minutes and I'm still stumped. Monthly, I pull data from SAP for a sales report. Each customer has a customer number assigned, but the report module does not communicate directly with SAP and I cannot connect the customer number. What I'm left with is using the customer name and a vlookup-true formula which is getting me into trouble. I know there is a workaround, but I'm not familiar with IF or ISNA formulas. Since they are mostly retail stores, they follow a numerical order and I should come out right at the end. Currently, I'm overstating my monthly sales by about 800%. ;-(
' =VLOOKUP(C3,[SAP4TDIVNHY6XYBRC7FOBWRCOGLK.xls]SAPBW_DOWNLOAD!$B$4:$X$830,23,FALSE) '
Valid data
Joes 1 = $100
Joes 2 = $200
Post-Vlookup
Joes 1 = $100
Joes 2 = $100
In all honesty, I didn't read the forum rules, so I hope I'm within the guidelines here. Thanks!
I've been reading for about 20 minutes and I'm still stumped. Monthly, I pull data from SAP for a sales report. Each customer has a customer number assigned, but the report module does not communicate directly with SAP and I cannot connect the customer number. What I'm left with is using the customer name and a vlookup-true formula which is getting me into trouble. I know there is a workaround, but I'm not familiar with IF or ISNA formulas. Since they are mostly retail stores, they follow a numerical order and I should come out right at the end. Currently, I'm overstating my monthly sales by about 800%. ;-(
' =VLOOKUP(C3,[SAP4TDIVNHY6XYBRC7FOBWRCOGLK.xls]SAPBW_DOWNLOAD!$B$4:$X$830,23,FALSE) '
Valid data
Joes 1 = $100
Joes 2 = $200
Post-Vlookup
Joes 1 = $100
Joes 2 = $100
In all honesty, I didn't read the forum rules, so I hope I'm within the guidelines here. Thanks!
