I'm struggling with a formula that will return all the charachters to the left of a "-", but I am having issues with #value when a "-" is not present in the lookup cell...
When the vlookup cell is blank I need the returned value to be blank (first part of the formula). The second criteria is to find "-". If "-" exists, return all text to the left. If "-" does not exist, then return all text.
Formula:
Please Login or Register to view this content.
Hi rjj920- try this:
Please Login or Register to view this content.
Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
Wow...that worked! Thanks, leelnich! What exactly is that formula saying? I don't understand what the & does...
Thanks again. this really threw me for a loop!
It just tacks a "-" onto the end of the return value, insuring that FIND will succeed when the original value doesn't have a hyphen.
You're most welcome, I'm glad I could help. If concluded, please mark your thread as SOLVED (Thread Tools above post #1). Regards – Lee
Last edited by leelnich; 03-25-2018 at 04:59 PM.
Ah...smart! Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks