Hello,
I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False)
The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False.
Pretty sure I am using the wildcard incorrectly or something. Thank you!
I have a Drop Down. Assume I select "Varia Single 25/2,3 90"
Now I want to return other values where either 25/2,3 or 90 are included. I want the whole value to be returned.
List
<colgroup><col></colgroup><tbody>
Pexflextra 25/2,3 90
<tbody>
Uno 25/2,3 76
<tbody>
MX-Radiflex 40/3,7...
I'm trying to do a vlookup with a partial match. I have a set of Item IDs and I'm trying to identify their item categories. Each item of the same category has the same abbreviation as part of their ID.
IDs
ABC12342 xyz
DEF73829 yzx
GHI93592 zyx
Key
ABC = Category 1
DEF = Category 2
GHI =...
Hi everyone,
I am searching for a non-VBA solution for the following problem if it exists.
I download regularly my bank account transactions from my netbank, which looks like this:
<tbody>
booking text
amount
Bezahlung Karte MC/000000230 28 00000014 MAESTRO POS...
Hey,
seeking for your help help help...
Is the formula below possible?
A Cells contains document reference, B cells are the document amount, C cells are combination of document reference(text) and D cells are the Total amount.
Cell A1, A2, A3, lookup to Cell C1, C2, C3 but and the return value...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.