Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation question, urgent pls help
Hey guys Hows it going? I really need your help. I am doing some work for my project and cannot seem to figure out how to sort out information in the drop-box. for example, I have information in rows/column ranging from: A4309 to B5396 the information in the A column is the main lookup value and the information in B column are the corresponding values ie. A (Team #) B (value) 251 1103 251 1104 258 9407 258 9408 etc ranging from once again, A4309 to B5396 Now when I try to validation the information in B5, ie. enter the TEAM # to get the corresponding value, I get the values for the entire B column. Also, it will not let me validate both A&B b/c it says the LIST is to large ($A$4309:$B$5396), and thus I can only select the VALUE column; leaving me with all the values but not the exact values for say team 251. I hope you can follow what i am asking. pls,pls let me know asap! thank you so muchh! really appreciate it! take care -- daroc ------------------------------------------------------------------------ daroc's Profile: http://www.excelforum.com/member.php...o&userid=30753 View this thread: http://www.excelforum.com/showthread...hreadid=504205 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation question, urgent pls help
See response in .excel
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "daroc" wrote in message ... Hey guys Hows it going? I really need your help. I am doing some work for my project and cannot seem to figure out how to sort out information in the drop-box. for example, I have information in rows/column ranging from: A4309 to B5396 the information in the A column is the main lookup value and the information in B column are the corresponding values ie. A (Team #) B (value) 251 1103 251 1104 258 9407 258 9408 etc ranging from once again, A4309 to B5396 Now when I try to validation the information in B5, ie. enter the TEAM # to get the corresponding value, I get the values for the entire B column. Also, it will not let me validate both A&B b/c it says the LIST is to large ($A$4309:$B$5396), and thus I can only select the VALUE column; leaving me with all the values but not the exact values for say team 251. I hope you can follow what i am asking. pls,pls let me know asap! thank you so muchh! really appreciate it! take care -- daroc ------------------------------------------------------------------------ daroc's Profile: http://www.excelforum.com/member.php...o&userid=30753 View this thread: http://www.excelforum.com/showthread...hreadid=504205 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Question....Can this be done? | Excel Discussion (Misc queries) | |||
Another Data Validation question | Excel Discussion (Misc queries) | |||
A new twist to the validation drop-down width question. | Excel Discussion (Misc queries) | |||
Validation Data & Goto question | Excel Discussion (Misc queries) | |||
Data Validation list selection question | Excel Worksheet Functions |