-
Show user form
HI
I have sheet in which if i enter a word in column D2, it should value from C which matches in column in A i cannot go for Vlookup as if i have two same first name its difficult for me to pick from C the matching one.
Can any one help if i enter a value in D2 if that value exists in column A more than ones then it should a user from all the matching values in C for the same word clicking on the required one should store in E2
-
Hi, rajesh nag,
have a look at the download Multilookup from Erlandsendata (If you look up numbers/text from lists/databases that contains several duplicate values, you will have use for this function. If the value you are looking for occurs more than once, the function displays a dialogbox that lets you select which value you want the function to return.).
Ciao,
Holger
-
If this is your data is columns A and C:
Smith apple
Jones banana
Adams coconut
Smith date
Jones eggplant
Jones fennel
And the user enters "Smith" in D2, you want a form to appear, letting the user choose between "apple" "date" and "fennel".
This UDF might help you. In E2, put =LookupMultiMatch(D2,A:A,C:C,TRUE,FALSE).
The searchTerm, searchRange, and resultRange are required arguments.
The optional boolean arguments MultiSelect and EmptyStringNotAccepted default to False.
The routine calls a userform with 1 list box, 1 label and 1 command button.
-
Hi ,
Thanks for the help but in my file i have used that formula in E7, Value will be stored in the same cell, i want the value to be stored in E8 and formula in E7,
can you help me on this
regards
-
No formula in E7 can store its value in E8.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules