if vlookup returns a 0, do another vlookup

BNM8V6

New Member
Joined
May 8, 2021
Messages
1
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. MacOS
im having a hard time figuring out a formula and I don't even know if its possible.

I have an attendance sheet full of email addresses of people who attended an event. I want to match this attendance sheet up with my roster that I have on a separate sheet to note who from the attendance sheet is on my roster. My dilemma is that some people are using a different email address than what I have on my roster when they attend the event. So it is showing that they weren't in attendance when I do the vlookup because its not finding the exact email I have on the roster. I added a second column to indicate a possible alternate email address that was used. I want the formula to basically say "if the vlookup returned a blank from column D, do another vlookup to find the other email address from column E. I hope I am being clear...
 

Attachments

  • Screen Shot 2021-05-08 at 12.54.50 AM.png
    Screen Shot 2021-05-08 at 12.54.50 AM.png
    42.3 KB · Views: 5

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
4,790
Office Version
  1. 365
Platform
  1. MacOS
EDIT

=IF( Vlookup-Formula1=0 , Vlookup-Formula2 , Vlookup-Formula1 )

Then you can ADD Error handling if needed for a 0 return

=IF(Vlookup-Formula1=0,IF(Vlookup-Formula2=0,"No Match 2nd Vlookup",Vlookup-Formula2),IF(Vlookup-Formula1=0,"No Match 1st Vlookup", Vlookup-Formula1))
 
Last edited:

Forum statistics

Threads
1,136,798
Messages
5,677,801
Members
419,720
Latest member
kurman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top