| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data from another worksheet based on user input
Dear Sir/Mdm,
Can anyone advise me how to perform the following in Excel? On worksheet B, I have a list of data in column A. Eg, A1=Holland, A2=England, A3=New Zealand, A4=Australia, A5=Asia. What I want to achieve is whenever I type any key in worksheet A on a Cell B2, it is able to lookup the information from A1 to A5 in worksheet B and display the value in Cell B2 of worksheet A. Please advise and many thanks. Alvyn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show a number of rows based upon user input | Excel Discussion (Misc queries) | |||
| Moving data in one excel column to another sheet based on user input | Excel Discussion (Misc queries) | |||
| Incrementing Data based on user input | Excel Discussion (Misc queries) | |||
| I would like to sort a work sheet based upon user input value,(dat | Excel Worksheet Functions | |||
| Finding a record based on user input | Excel Discussion (Misc queries) | |||
Threaded Mode
