Excel Microsoft Excel 2013 - VLookup Question


Joined
May 2, 2014
Messages
2
Reaction score
0
Hi All,

My name is Michael, I hope you are all well.

I have an excel "database sheet" which follows the following pattern

A - 1 - #
A - 2 - #
A - 3 - #
B - 1 - #
B - 2 - #
B - 3 - #

And so on. In this example, #=varying number. A/B/1/2/3 are repetitive data strings.

In a separate sheet, I have a data validation drop down field which will allow the user to first select A or B, then in a second data validation field, they may choose 1, 2 or 3.

My aim from this, is to "vlookup" (or some other command) both sets of data to find a matching '#' in the "database sheet". So if the user selects A and then 3, they will output the # in row C.

Hope this makes sense and I hope somebody can help.

Thanks in advance.

Kind regards,

Michael
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top