Pull Contact Name out of Table based on Business Name in same Row using VBA.

[EnigmaMatter]

Hello All,

Setup:

On Sheet1, I have Table1. Table1 contains three columns: Business Name, Contact Name, e-Mail Address.

On Sheet2, I have ListBox1 which contains Business Name(s).

When the user selects a Business Name (or Names), and then hits CommandButton1, the remaning code will generate a report.

How would I make it so that cell D4 on the newly generated report will be equal to the CONTACT NAME, based on the given Business Name?

I realize this is a tough one...thanks for all of your help in Advance.

[TMS]

Use VLOOKUP with the Business Name as the item you are searching for.

Regards, TMS

[EnigmaMatter]

How would I do that in VBA?

[TMS]

Something like:

Please Login or Register  to view this content.

Regards, TMS

[EnigmaMatter]

Excellent!

I appreciate it.

[TMS]

You're welcome. Thanks for the rep.