I'm trying to figure out how to perform two separate look-ups in one statement:
I need to search by BOTH email address and Network ID, as my look-up table is sometimes missing either of the values. So, i want it to first match based on the Network ID. If that produces a null return, perform a second look-up matching on email address.
Hi and welcome to the forum
I will take a look at your file, but a quick answer...
=iferror(vlookup()1,vlookup()2)
with vlookup()1 being the vlookup for the ID and vlookup2 for the email
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
lol..thank you, FDibbins! I was making it way too complicated. Ochham's Razor, Nicole - Ochham's Razor
Hi Nicole,
Maybe:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks