# if vlookup returns a 0, do another vlookup

#### BNM8V6

##### New Member
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
42.3 KB · Views: 10

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### etaf

##### Well-known Member
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:

Replies
0
Views
135
Replies
5
Views
107
Replies
20
Views
804
Replies
24
Views
662
Replies
1
Views
511

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,844
Messages
5,766,748
Members
425,378
Latest member
kapoor2892

### 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.

### Which adblocker are you using?

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

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