When using the data in a cell as a reference for a vlookup how do I only
consider the first three characters in that cell.
ie,
=VLOOKUP(A1,A1:B10,2,FALSE)
but I only want to consider the first three characters in A1
Thanks,
Rick
When using the data in a cell as a reference for a vlookup how do I only
consider the first three characters in that cell.
ie,
=VLOOKUP(A1,A1:B10,2,FALSE)
but I only want to consider the first three characters in A1
Thanks,
Rick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks