Validation with vlookup
Hi to everyone,
Anybody knows how 2 make a validation with a vlookup as formula?
I have 2 lists in 2 columns (A & B). In column A I have numbers and in B names, and what I want is something like if in C1 I type 1 it will appear the name that is in front of that number in the list.
Expl:
A.....B.............C
1...Joe.........Type 2 but will appear Carol
2...Carol
Thk u for any help
What you're looking for is dependent data validation. Have a look here
http://www.contextures.com/xlDataVal02.html
Life's a spreadsheet, Excel!
Say thanks, Click *
You cannot have both a manual entry and a formula. The only way to do what you are asking (within the same cell) is by using VBA.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Ace_XL,
Thk u for your reply but that page not help me anyway because it is not what I want: what I want is work with only 1 cell - not with 2 or 3.
Thk u anyway.
---------------------
ChemistB,
I know - I mean, I can understand - that I "cannot have both a manual entry and a formula" but I think is not the case .cause I don.t use any formula in the cell, only in the validation> formula.
Anyway, thk u for ur reply.
You can use equations in Data Validation to determine what you can manually enter (i.e. List1 or List2) but in the end, it's a manual entry. If you want to Choose "1" and return "Carol" you'll need VBA.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks