LOOKUP between two columns of diff. size
This worked well and as a bonus, let me know that I had some duplicates on
the first sheet. This turned out to be something important to know. Thanks
much teethless.
"Teethless mama" wrote:
Try this:
=COUNTIF(Sheet1!A:A,LEFT(A1,6))
"CapFSU" wrote:
have a sheet w/ list of 80 different 6 digit codes. have a second sheet w/
over 13,000 8 digit codes. Trying to figure out how to lookup in the second
list to see if any of the 13,000 first 6 digits of the 8 digit code match any
of the list of 80. Any ideas?
|