Is there a way to lookup a 4 digit number and from the table the lookup will find the 4 digit number and count over 3 and that number is 4 digits but I only want the first three digits of that number
Vlookup(a1,range,3,false)
the 3 (column index number)is the question when it counts over three to pull that number its 4 digits but I want the first three only
Thanks!
Vlookup(a1,range,3,false)
the 3 (column index number)is the question when it counts over three to pull that number its 4 digits but I want the first three only
Thanks!