Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help on Lookup Function
This post was originally posted to the excel.worksheets.function forum on
August 20. However as at this time of writing, I still do not get any help from the forum mentioned above. Maybe I have posted into the wrong forum. I hope some one from this forum can help me out with the problem below. Best regards David I have a table as below in my 2nd worksheet: Part No. Location Qty AAA T65 1 AAA T65 2 AAA T77 5 BBB T65 3 BBB T65 5 CCC T77 6 DDD T77 7 In my first worksheet I have column A populated with my Part No.: A B C 1 AAA 2 BBB 3 CCC 4 DDD 5 EEE I would appreciate very much if some one is kind enough to guide me on how to to a VBA in column C. Can I do a combox box data validation on column C? If user click on row 1, column 'C' combo box, then I need the combo to display a list as shown below: AAA T65 1 AAA T65 2 AAA T77 5 Ideally all the 3 rows information above should be inside a combo box or a comments box. TIA, Best regards David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining Lookup function and Sum function | Excel Worksheet Functions | |||
LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |