How can I copy the formula result formatting?
How can I get the formula result in the correct custom format instead of doing each one individually? C4 & H4 are country and product, column 8 is sales quantity.
Formula on sheet 1:
=IF(COUNTIF('Sheet 2'!$A$53:$Z$5000,C4&H4), VLOOKUP(C4&H4,'Sheet 2'!$A$53:$Z$5000,8,0)," ")
Sample of column 8
0.384 kg
0.128 kg
0.165 kg
1.189 EA
0.171 L
0.356 EA
9.180 kg
2.225 L
6.182 kg
341.667 L
Help is appreciated!
If the units are in the lookup table as a result of custom formatting in those cells, you can't (without VBA).
You could put the units in a separate column of the lookup table and retrieve them with a second VLOOKUP.
Entia non sunt multiplicanda sine necessitate
The units are the result of a BW query from SAP.
Then I guess I'm missing the question. The lookup will return exactly what's in the cells, which is text.
the query result is just the number, but it is formatted for the quantity. Sounds like this is a query problem, nothing that can be resolved by the formula?
Still clueless as to what the data actually looks like. Can you post an example workbook?
Hi M Neff,
Welcome to the forum!
shg had it right in his first response. SAP BW/BI adds the units of measure as formatting in each cell. You won't be able to bring this through a formula without VBA.
Cheers,
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Thank you, CXL.SAP BW/BI adds the units of measure as formatting in each cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks