Combine pull down + Vlookup return values in multiple cells

  • Thread starter Thread starter M G Henry
  • Start date Start date
M

M G Henry

I am working on a project that I believe shoud have pull downs and
vlookup to return the values to multiple cells.

My concept is this....
I have a pulldown on a Form! page in cell b3 It pulls values from
tables! in my workbook with values ranging from a1:a10.

I would like the returned result.... for example... Michael

to then lookup on tables! from a range of c15:e500 the following
information.

The values of column C are Names
column D are job Numbers
column E are job descriptions.

so the pull down results from b3 on the forms page will limit the
possible names in column C from Tables! to only my work.
B4 has another pull down from the Job Numbers column that will show
only the numbers I opened.
selecting the proper number in B4 will then bring over the information
in the adjoining tables! column E and place it in cell B5

Would it be correct to use a combination of pull downs and vlookup to
achieve this....

any help would be appreciated.
 
That's generally known as 'cascading list boxes' (or combo boxes)-
google should pull all sorts of help sites.

Data Validation, Lists, Named ranges and Indirect are probably the way
to go though, as opposed to Vlookup

Post further if you can't find exact guidelines and I'll post a full fix
or an example file.

Jason
 
Back
Top