LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 159
Default Data Validation used with VLookUp function

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Validation, VLookup or If ??????? dragons_lair Excel Discussion (Misc queries) 3 May 27th 09 09:02 AM
Vlookup in data validation??? ChrisP Excel Worksheet Functions 1 July 11th 08 03:36 PM
Data Validation vs VLOOKUP - Linking to data in a seperate file Sharon Excel Worksheet Functions 3 May 15th 08 07:43 AM
Data Validation on Vlookup markmcd Excel Discussion (Misc queries) 6 November 13th 07 05:23 AM
How to use both Vlookup & data validation shital shah Excel Worksheet Functions 1 August 4th 06 08:28 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"