# tbd

1. ### Dynamically pulling information when data is inconsistent

I have a bit of a logic problem I'm trying to figure out. I have data that has inconsistent attributes and I want to figure out if I can programmatically extract the data: My data has a SINGLE column. Column A reflects the individual entries and the attributes associated with them. Column B...
2. ### INDEX / SMALL / (match?) partial lookups, multiple criteria

Having no luck getting my head around the order or events and hoping it's easier than I'm making it out. Two columns- column A is a list of names; column B is either a numerical entry or "tbd" for 'to be decided. Want to put out a list of names where the first two characters can be the "tb" in...
3. ### Add numbers from cells in column A, depending on text in column B

I'm having a small problem getting a workable solution created for the below. My data - In column A, I have range of percentage values, accumulating to 100%. Each row can have a value of anything from 0.01% up to 100%. - In Column B, next to the percentage value, I have a text value which is...
4. ### Vlookup + sumif with multiple arguments in a single cell

Hey guys. I need a formula to lookup the sales orders then add the amounts so it equals 118.00 in the "TBD" cell. <tbody> Sales orders Total amount Sales orders Amount 123456789 / 234567890 TBD 123456789 56.00 234567890 62.00 Total 118.00 </tbody> I could "Convert text...

### We've detected that you are using an adblocker.

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.

### Which adblocker are you using?

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

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.
Go back