mrsbrannon
Board Regular
- Joined
- Mar 7, 2018
- Messages
- 61
Hello all,
I am trying to organize/count my raw data coming in from my ecommerce site. I'm pulling from the raw data onto another sheet in the workbook and I need VLookup + the IF function to look for variables of very long, specific text. It's the only way the data pulls over and I'm struggling. I've done this before, but it's been a good 3 years and I am rusty. I use tables, not numbered cells. I know it's doable, because I've done it before, but can someone refresh my memory? Going to insert some mockup tables for examples. The first one is the long string of data. I have highlighted what I'm looking for on the second mock table (keep in mind, this is on another sheet). 1st table is titled RawData and the column number is 26.
The formula I am doing, which I know is not correct is: =IF(Vlookup("Number of Children (for crafts, activities, etc.):1",RawData,26,FALSE),1,"")
I hope this makes sense. I'm trying to extract the number of children from the raw data and place into my org table.
I am trying to organize/count my raw data coming in from my ecommerce site. I'm pulling from the raw data onto another sheet in the workbook and I need VLookup + the IF function to look for variables of very long, specific text. It's the only way the data pulls over and I'm struggling. I've done this before, but it's been a good 3 years and I am rusty. I use tables, not numbered cells. I know it's doable, because I've done it before, but can someone refresh my memory? Going to insert some mockup tables for examples. The first one is the long string of data. I have highlighted what I'm looking for on the second mock table (keep in mind, this is on another sheet). 1st table is titled RawData and the column number is 26.
Item Variant |
---|
Number of Children (for crafts, activities, etc.):1 | Child's Name and Age:Bobby, 6 | Number of Days Desired:8 |
Number of Children (for crafts, activities, etc.):2 | Child's Name and Age:Tommy, 6 | Number of Days Desired:8 |
1 Child | 2 Children | 3 Children |
---|---|---|
1 | 2 | 3 |
1 | 2 | 3 |
The formula I am doing, which I know is not correct is: =IF(Vlookup("Number of Children (for crafts, activities, etc.):1",RawData,26,FALSE),1,"")
I hope this makes sense. I'm trying to extract the number of children from the raw data and place into my org table.