# 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: 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
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
24
Views
467
Replies
0
Views
98
Replies
15
Views
149
Replies
1
Views
136
Replies
1
Views
52

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.

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