Hi,
I m trying to find a surname within a field, the field length changes, to bring up a number related to the employee (EE), from a different column
I am typing the EE surname on the Vlookup formula "Smith", from Column 2 and asking to bring the number from Column 4
Is there another way to make this quicker within the formula
Many thanks,
J
See file attachedFormulafinding.xlsx
See file attached
Last edited by josvill; 10-05-2016 at 09:04 AM. Reason: attaching file
In C6, copied down
=VLOOKUP(TRIM(RIGHT(SUBSTITUTE(TRIM(A6)," ",REPT(" ",50)),50)),LookupNames,3,0)
You misspelled Donovan (Donova) in CompanyA E7 (I added an N in caps..) Try to avoid trailing spaces (e.g at the end of A6, where there are two).
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If you have NO leading/trailing spaces (much better!!) the formula above can be changed to:
=VLOOKUP(TRIM(RIGHT(SUBSTITUTE(A6," ",REPT(" ",50)),50)),LookupNames,3,0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks