abarbee314
New Member
- Joined
- Apr 5, 2013
- Messages
- 24
Howdy folks!
You've been my rock many times so I'm hoping someone here has a suggestion.
Below is a sample of a spreadsheet with two small bits of data. Start Here is where we need to see if the RANGE of numbers covered by the Bates label columns are found in *ANY* of the values in SHEET 1. World's worst vlookup.
Description:
Yes, I thought about text to columns and concatenate, but it doesn't work for all entries in SHEET 1. As you can see, many of them have a range listed themselves, minus leading values, while others have EXTRA text.
Anyway, I told you it was "not-too-friendly". I welcome any suggestions or thoughts!
THANKS!
Aaron
<tbody>
</tbody>
<tbody>
</tbody>
You've been my rock many times so I'm hoping someone here has a suggestion.
Below is a sample of a spreadsheet with two small bits of data. Start Here is where we need to see if the RANGE of numbers covered by the Bates label columns are found in *ANY* of the values in SHEET 1. World's worst vlookup.
Description:
- "Start here" shows various bates number ranges
- We would like to know if the ranges in that set cover ANY of the values shown (horribly) in SHEET 1
- Yes, SHEET 1 is also ranges, so we're trying to find the cross-over between those values. But obviously they were recorded differently.
- There are over 10,000 rows of data involved, otherwise I'd just tell them to crank thru manually
Yes, I thought about text to columns and concatenate, but it doesn't work for all entries in SHEET 1. As you can see, many of them have a range listed themselves, minus leading values, while others have EXTRA text.
Anyway, I told you it was "not-too-friendly". I welcome any suggestions or thoughts!
THANKS!
Aaron
START HERE | |||
BeginBates | EndBates | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody>
</tbody>
SHEET 1 | |
<tbody> </tbody> | |
<tbody> </tbody> | |
[BLANK] | |
<tbody> </tbody> | |
[BLANK] | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> |
<tbody>
</tbody>