LinkBack URL
About LinkBacks
Hello All Again,
The below code works perfect for one column, but I have another column which needs to be checked, and the corresponding value returned. Any ideas or help would be greatly appreciated.
Please Login or Register to view this content.
Hello All Again,
The below code works perfect for one column, but I have another column which needs to be checked, and the corresponding value returned. Any ideas or help would be greatly appreciated.
Please Login or Register to view this content.
When you say another column, are you referring to the result found in a column other than 2 as shown in your formula or do you mean you want the vlookup to seek the criteria in a column other than Column S. And are you looking for the results to be returned to column N as you currently have.Specifics are important to addressing your issue. To many variables here!
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hello-currently the code looks at Column E in "CallData" checks for a match in "Callagentname" and returns the value if matched. I need it to also look in Column K in "CallData". Hope this makes sense.
If it finds a match for column E and finds a match for column K, which value to return? E or K?
Basically, there would never be a valid value in both columns in the same row. Hope this makes sense. Thanks.
This is crude I know, but this is the basic concept:
Please Login or Register to view this content.
In that case, insert a line of code below the line
Please Login or Register to view this content.and see if that works for you.Please Login or Register to view this content.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
When I added that line, it bypasses the first line of code, and only applies the 2nd Vlookup.
Please Login or Register to view this content.
Try this:
abousettaPlease Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
ABOUSETTA!!!!! YES YES YES!!! You are BRILLIANT MY FRIEND!!! Thank-you so much!!! Thanks for everyone else's help as well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks