I have a vertical lookup which is pulling information from another worksheet
within the same workbook. I want to be able to have the formula look in
worksheet #1 and if it does not find it in that worksheet - go to worksheet
#2 and do the same vertical lookup.

Can someone help me format this? Thanks!