Vlookup with multiple results

[robertsgw]

I'm trying to write of formula to that will allow me lookup a customer property and tell me their invoices outstanding from another excel tab. I have been using a vlookup, but it only comes up with the first occurrence. Below is an example. So on another tab I would enter ABC ST and the formula would pull all the invoices for ABC ST. Thanks.

COLUMN A COLUMN B COLUMN C
customer pro invoice # Amount
ABC ST 1234 5000
ABC ST 5678 60000
CBDG 91878 7000
PEFGR 87890 8000
GJERS 7856 9000

 

[T. Valko]

One other question for you. How do you copy a macro from one workbook to a new workbook. I tried right clicking on tab of old workbook and did a move/copy to new workbook. Doesn't seem to be working.

If it's just a "few" lines of code I'll just open the module and highlight the code then copy and paste into a module in the other file.

Another way...

Right click the code module>Export File
Save it in an easy to reach location

Open the other file
Open the VBE
Right click the file name>Import file
Select the module name

 

[T. Valko]

It worked, Thank you.

Good deal. Thanks for the feedback!

 

[robertsgw]

Thanks for the help. On to another project and ran into some problems. I don't know if this is even possible. On one sheet I want to have a number is 12345689 which will be say an invoice number. This first sheet is just a summary sheet of invoices numbers. If possible I want to click on the invoice number on the summary sheet and that will automatically open another sheet which will be the detailed invoice. Kind of like a hyper link. Is this possible?

 

[T. Valko]

Thanks for the help. On to another project and ran into some problems. I don't know if this is even possible. On one sheet I want to have a number is 12345689 which will be say an invoice number. This first sheet is just a summary sheet of invoices numbers. If possible I want to click on the invoice number on the summary sheet and that will automatically open another sheet which will be the detailed invoice. Kind of like a hyper link. Is this possible?

Is the invoice number also the name of the sheet that you want to be taken to?

 

[robertsgw]

yes, it is.

 

[T. Valko]

yes, it is.

Ok, you can do something like this...

Book1
	A	B
1	Invoice	Goto
2	123	123
3	456	456
Sheet1

Column A is the invoice number and column B is a hyperlink to that invoice sheet.

This formula entered in cell B2 and copied down as needed:

=HYPERLINK("#'"&A2&"'!A1",A2)

When clicked that will take you to cell A1 of the invoice sheet.

 

[robertsgw]

Let me give it a whirl. Thanks for the help.

 

[robertsgw]

So this formula will take me to another tab in the same workbook?

 

[T. Valko]

So this formula will take me to another tab in the same workbook?

Yes

Here's a small sample file that demonstrates this.

zzzRobertsgw.xls 16kb

http://cjoint.com/?AIpwsO5XLBA