Data Validation used with VLookUp function

G

Guest

How can I use the data validation tool in a column on sheet1 based off of
data from sheet 2 a1-a50(I do know how to use the tool), where if you choose
say 'xx'(the value from a1) from the drop down list the function will return
the value from sheet2 b1 instead of a1.
 
G

Guest

You need to have 2 columns in the sheet 1. Fitst (a1) will be the result
selected in the drop down, the second (b1) will be your vlookup that will
return your value.

Also, on data validation in order to read the data list from sheet 2 the
range has to be labled for example 'Range1". Then in the validation box you
need to call up that RangeName
 

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

Similar Threads

A data validation question 1
Help with drop down list selection 2
data lookup/validation syntax 2
Conditional Validation In Excel 1
lastrow function help 6
If formula and Data Validation parallely 1
comparing 2 worsheets using a macro 1
Data Validation - Dependent List 3

Top