Vlookup with multiple results

[dsrt16]

I am creating a database with authors, book titles, descriptions, and prices. When I type in a specific authors name in cell C3 I need all the titles in the datbase to appear. I know how to get one to do so, but not all of them.

=VLOOKUP(C3,Book List!A5:D563,2,FALSE) will return one of the book titles.

I have a table set up on the Book List worksheet with author, book title, desciption, and price. I have it set up where I only type the authors name once in the first column then in the second column I list their book titles. After listing their titles then I move on to the next author like this:

Then when I enter Name of Author in cell C3 I want cell C5 to list all the books of that author. (aka A fun title, Another Title, Yeah).
However with the formula I have above it will just list the first title. (aka A fun title)

Edited by NateO: Tried to clean up the table.

Edited by NateO, again: Nope, not working. Deleted the table. You might be interested in the HTML Maker, here:

http://www.puremis.net/excel/downloads.shtml

 

[cgmojoco]

There probably is, but I am not aware of how and if it would be easier or not...

 

[maven]

Hi guys,

It's been a while since I've posted here but I'm back with another variation of the Multi VLookup thing. I've played with the foo code and other variants and while it will select the data I want I'd love if it could be arranged in the columns and not just the rows. If it's possible I'd love to have it come out like a pivot table arrangement in a new worksheet.

I'll try to show what I mean here.

In this report I have recorded the many many many problems with the project...

Excel Workbook
	A	B	C	D
1	TagNo	Description	Opened By	Opened Date
2	061FI-10003/E	commissioning will install	James	04 February 2009
3	061FI-10017/E	mech not install	John	19 May 2009
4	061LCA-21001/TX	NO VESSEL TO ACCESS	Steve	01 December 2008
5	061LCA-21001/TX	tank incomplete.radar level to be insatalled by piping	David	15 July 2009
6	061PG-10006/G	PIPING INCOMPLETE	Jim	23 March 2009
7	061PG-10006/G	commssioning will insatll/monoflange to be install by piping	John	30 January 2009
8	061PG-10006/G	WAITING FOR THE INSTRUMENT TO COME FROM THE WAREHOUSE	Alan	16 August 2009
9	061QIA-10130/E	commssioning will install	David	21 January 2009
10	061QIA-10251/E	commssioning will install	Steve	14 May 2009
Constraints Report

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	TagNo	Instrument_Type	Service_Description	Primary Cable Installed	Primary Cable Termn FAR END	Primary Cable Termination Field/JB End	Secondary Tray Installed	Branch Cable Complete Terminated at Instr side.	Branch Cable Complete Terminated at JB side.	Instrument Installed	Tubing Installed
2	061LCA-21001/TX	RADAR LEVEL TX FB (FREE SPACE)	0T6101 NCC TANK	Yes
3	061FI-10003/E	ORIFICE PLATE	0P6101A-L COND TO 1E6149	N/A	N/A	N/A	N/A	N/A	N/A	N/A	N/A
4	061PG-10006/G	PRESS GAUGE	0P6101A DISCHARGE	N/A	N/A	N/A	N/A	N/A	N/A
5	061FI-10017/E	VENTURI	0P6101A-L TO 0V6201-8	N/A	N/A	N/A	N/A	N/A	N/A
6	061QIA-10130/E	SAMPLE PROBE	0P6101A-L TO 0V6201-8	N/A	N/A	N/A	N/A	N/A	N/A
7	061QIA-10251/E	SAMPLE PROBE	1E6148 PCC TO 1T6141	N/A	N/A	N/A	N/A	N/A	N/A
Excel 2007 This is the report we use to show activity progress... Progress Report

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K
1	TagNo	Instrument_Type	Service_Description	Constraint Remarks	Opened By	Opened Date	Primary Cable Installed	Primary Cable Termn FAR END	Primary Cable Termination Field/JB End	Secondary Tray Installed	Branch Cable Complete Terminated at Instr side.
2	061LCA-21001/TX	RADAR LEVEL TX FB (FREE SPACE)	0T6101 NCC TANK	NO VESSEL TO ACCESS	Steve	01 December 2008	Yes
3				tank incomplete.radar level to be insatalled by piping	David	15 July 2009
4	061FI-10003/E	ORIFICE PLATE	0P6101A-L COND TO 1E6149	commissioning will install	James	04 February 2009	N/A	N/A	N/A	N/A	N/A
5	061PG-10006/G	PRESS GAUGE	0P6101A DISCHARGE	PIPING INCOMPLETE	Jim	23 March 2009	N/A	N/A	N/A	N/A	N/A
6				commssioning will insatll/monoflange to be install by piping	John	30 January 2009
7				WAITING FOR THE INSTRUMENT TO COME FROM THE WAREHOUSE	Alan	16 August 2009
8	061FI-10017/E	VENTURI	0P6101A-L TO 0V6201-8	mech not install	John	19 May 2009	N/A	N/A	N/A	N/A	N/A
9	061QIA-10130/E	SAMPLE PROBE	0P6101A-L TO 0V6201-8	commssioning will install	David	21 January 2009	N/A	N/A	N/A	N/A	N/A
10	061QIA-10251/E	SAMPLE PROBE	1E6148 PCC TO 1T6141	commssioning will install	Steve	14 May 2009	N/A	N/A	N/A	N/A	N/A
Excel 2007 What I need is to combine these two kinda like a pivot table/multi Vlookup and combining the two worksheets? Wish

Excel 2007



I must say thanks to RichardSchollar he's a smart man to have made the HTML maker I used here. It's just so easy to use

Anyway I hope someone can help me cus I'm out of ideas at the moment
Thanks in advance

 

[Edleets]

I found this post which is very similar to what I was looking for.

Looking at Just Jon's code, it only does the selection for one target (AAA) in sheet1. I need the same thing but to continue with the next target (XXX) right below last data of previous target and so on, until last target listed in Sheet1.

Since the list of target in sheet1 will be located in a fixed cell in column A, the amount of available rows will be defined to every target. The VBA code needs to consider inserting a line if the amount of data for an specific target is greater than available rows.

Can someone update Just Jon's code to my needs?

Thanks