LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jparker
 
Posts: n/a
Default vlookup with validation table


First, I know about the Copy-Paste Special command. However, I want to
use a vlookup table that will lookup an item that is typed in cell A1
and display the result in cell A2. The lookup table is cells P1 to
P10. That part is simple. The cells in the lookup table are blank
except for their own validation table. I would like cell A2 to display
the validation table for the value of cell A1.


--
jparker
------------------------------------------------------------------------
jparker's Profile: http://www.excelforum.com/member.php...o&userid=26155
View this thread: http://www.excelforum.com/showthread...hreadid=394806

 
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
Using Vlookup with validation Brian Excel Worksheet Functions 4 May 4th 23 03:43 AM
Table Array in VLOOKUP Relies on Data Validation willydlish Excel Worksheet Functions 2 February 16th 05 03:20 AM
I have a validation box on one page and a table on the other how . chris Excel Discussion (Misc queries) 1 February 11th 05 11:46 AM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM
Validation List and VLookup are ackting strange Jasper Excel Worksheet Functions 1 January 24th 05 01:49 PM


All times are GMT +1. The time now is 09:10 PM.

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

About Us

"It's about Microsoft Excel"