Hi,
I am tring to find a value (i.e. "30") within range of cells all of which contain numerous values separated by commas. I cannot use the vlookup with the asterisk wild card because I retriece data related number 3098 and so on...How do I specify the exact value within the cell to only the get the desired number?
Thanks in advance!
Post some sample data and tell us what result you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Give this a try:
Please Login or Register to view this content.
Gary's Student
maybe try
*,30,*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks