| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to create a multi column lookup list?
This is in Excel 2007.
In my 1st worksheet I have a list of books with 4 columns: ID, Title, Authors, Owner On a 2nd worksheet I have the following columns: ID, Checked out to, Date I want in the lookup list for ID in my 2nd worksheet to show the Title, authors and owner columns but only return the ID of the book. I can create a lookup list that contains only one column. Any ideas or suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a column from e-mail TO: list | Excel Discussion (Misc queries) | |||
| create a list dependant on info in a column | Excel Worksheet Functions | |||
| match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
| How do I create a list of items in a column? | Excel Worksheet Functions | |||
| Multi-Column Drop-down list ? | Excel Discussion (Misc queries) | |||
Threaded Mode
