vloopup and data vadilation

V

vcff

I have a data base in a worksheet from cell AM2:AY605 (use for data
vadilation, which require the data to be under the same worksheet).

I have some formulas in the follwoing cells which help me to extract the
info .

AI : data vadilation for a dropown list of names under AM2:AM605 (for A1 :
A20)
B1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,2,0))
C1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,3,0))
D1 : =IF(A1="","",VLOOKUP(A1,AM2:AY605,6,0))
E1 : problem for me here

in E1, base on A1 selection, I will like to have a dropdown list to select
the info under AT1:AW1

As there are a total of 31 worksheets, representing 31 days, I need to have
the data info on every worksheet in order for the Data Vadilation to function
in column A.
Is there a way where I can put the data on a single worksheet and to extract
the info from there.

Help will be greatly appreciated.

Regards
vcff
 
V

vcff

sorry I miss out another point

F1 : will depend on E1 selection and refer to a dropdown list fROm AX1 :AY1
 

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

vlookup with dropdown list 2
vlookup with dropdown list 3
mapping? columns from one excel workbook to another 1
Creating a list of info in A1 cell in multiple worksheets 4
Data Validation List Macro 18
Copy a Range of Data Beginning and Ending with a Certain Value 1
Formula 3
Vlookup on mutiple worksheets 9

Top