Hi
i have a code below to fill out my lookups but there is something wrong on it. please help me to correct this code. I need to lookup P2 to 2 different sheets. P2 needs to find on Master sheet and Support sheet.
Please Login or Register to view this content.
This line of code is wrong but I don't know what you want to do so I can't tell you how to fix it.
A formula returns a single value. You have two values separated by a comma. For example, it wouldn't make sense to type this into a cell:Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
but that's basically what you have here.
What do you want in cell Q2?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Hi 6StringJazzer
cell Q2 is where i put the values where the lookups done.
.Formula = "=VLookup(P2,'Master'!$E:$J,5,False),VLookup(P2,'Support'!$E:$J,5,False)" is to find column P "Agent Name" to find their TL on Master Sheet and if not found on Master Sheet they can look it up to Support Sheet (tab).
If you have any codes that can help me to lookup Agent Name to find their TL on 2 different Sheets.is highly appreciated.
thanks
I have not tested this but here is the idea. If the first VLOOKUP returns an error then the second one will be used.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks