Office Software Thread, Data validation and Vlookup in Technical; Hi,
I'm trying to use a data validation drop down to select a subject in column D1, and in C1 ...
30th January 2014, 01:16 PM #1
Data validation and Vlookup
I'm trying to use a data validation drop down to select a subject in column D1, and in C1 I want the subjects Qualification code to populate.
Lots of forums are saying about indirect lookups or using named ranges.
Nothing i have read seems to work. Does anyone have any solutions?
30th January 2014, 01:18 PM #2
vlookup should work for that and named ranges are good practice for that. Can you upload your spreadsheet or enough of an example so we can see what might be going wrong?
30th January 2014, 03:35 PM #3
This is the sheet, should be pretty self explanatory...
actually ignore column B
that's something else i just tried to get it working.
Last edited by jimbojames136; 30th January 2014 at 03:36 PM.
30th January 2014, 03:48 PM #4
I add Subj Code to column D in sheet 2 and then select the block C2->D820 and give it the name "Desc2Code".
On sheet1, the vlookup then looks like =VLOOKUP(A2,Desc2Code,2,FALSE).
Vlookup needs the information you want to lookup to be to the right of the information you are using to look it up (the 2 in the column offset can't be negative).
Last edited by pcstru; 30th January 2014 at 03:50 PM.
Thanks to pcstru from:
jimbojames136 (31st January 2014)
31st January 2014, 09:22 AM #5
Yeah i can see what you mean now. Ive moved the columns and its worked fine. Quite a simple problem really.
thanks very much for your help pcstru.
Last Post: 31st January 2014, 04:37 PM
By Ric_ in forum Windows 7
Last Post: 27th April 2012, 02:32 PM
By klawd in forum How do you do....it?
Last Post: 16th September 2009, 11:25 PM
By ITWombat in forum Hardware
Last Post: 26th March 2007, 08:03 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)