I tried to install a macro in my workbook. Here is the syntax:
When I tried to use the function I got an error stating "Ambiguous name detected: VLOOKUPWORKBOOK".
Please Login or Register to view this content.
I'm very new to macros and would appreciate any help you could provide. I'm sure you'll need more info so just ask and I will give it to you! Thank you!
Last edited by arlu1201; 05-23-2013 at 12:47 PM.
How did you try and use it?
If posting code please use code tags, see here.
I have uploaded the workbook. I tried to use it on the tab titled "Master List" in cell D3.
If you don't want to look in the file, I entered it like this:
=VLOOKUPWORKBOOK(A3, 'TS-5D1'!D3:D103, 4, 0)
lulu,
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Okay so I figured out my problem. It was a stupid little mistake.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks