I would like my vlookup function to look for a value in one sheet and if it
doesn't find it, look in another sheet. Is this possible?

I was considering using a nested if function but not sure how.