My lookup is returning #N/A for some reason
It's looking up the first number of a 4 digit number. some may start with a number some may start with a letter. the letter comes back ok but the number doesn't
Here is my formula =vlookup(left(a3,1),ship,2,0)
Thanks
It's looking up the first number of a 4 digit number. some may start with a number some may start with a letter. the letter comes back ok but the number doesn't
Here is my formula =vlookup(left(a3,1),ship,2,0)
Thanks