Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation, VLookup or If ??????? | Excel Discussion (Misc queries) | |||
Vlookup in data validation??? | Excel Worksheet Functions | |||
Data Validation vs VLOOKUP - Linking to data in a seperate file | Excel Worksheet Functions | |||
Data Validation on Vlookup | Excel Discussion (Misc queries) | |||
How to use both Vlookup & data validation | Excel Worksheet Functions |