EXCL of LOOKUP can not show all? ?
[Users questions | Browse:57 | Favorites]
Users questions: I made a table in Sheet1 is the device for more information on Sheet2 is the case of printing equipment. Numbers in Sheet1 in a cell above the setting for the validity of the option number on Sheet2, I use the LOOKUP command to refer to this cell. In S heet1 selected number can be displayed on Sheet2 in the case of the number of equipment, recently found in the selected numbers in Sheet1 Sheet2 in after some show up. Some middle of the number do not know how, who can help me next ah
Experts answer:: 1, according to title Intended to "Device Details" table to set the validity under the closer the arrow A1. 2, in the "printing device" Table A2: E2 set formula. 3, as long as the "Device Details" table A1 select the number "printing device" Table A2: E2 can automatically display the appropriate information. Attachment: query. Xls
Experts answer:: 1, according to title Intended to "Device Details" table to set the validity under the closer the arrow A1. 2, in the "printing device" Table A2: E2 set formula. 3, as long as the "Device Details" table A1 select the number "printing device" Table A2: E2 can automatically display the appropriate information. Attachment: query. Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.