Forum Discussion
Need help with Excel - finding the right formula.or function to use
I have a worksheet with many rows which I get from our financial team. One of the columns is a truncated name of a service in all caps. I have a separate worksheet with a list of full mixed case ...
SergeiBaklan - thanks - I actually solved it.......
1. My secondary sheet with the full names needed to be sorted.
2. I used this VLOOKUP
=VLOOKUP(TRIM(AO44) & "zzz",SvcNames!$A$2:$A$40,1,TRUE)
Yes, if that's trimmed, not shortened names, approximate search could work. Thank you for the update.