I have this formula which refers to the Master Tab.

=VLOOKUP($B4,MasterTab!$H$21:$O$923,8,FALSE)

It usually works great, however, when the data is not found ( because it's
on another worksheet ( Minor Tab!), I get a #N/A.

How can I re-write the formula that if the #N/A is produced, it does the
Vlookup on the Minor tab! instead of the master tab!

Something like: If =VLOOKUP($B4,MasterTab!$H$21:$O$923,8,FALSE) produces a
#N/A, VLOOKUP($B4,MinorTab!$H$21:$O$923,8,FALSE, if not, use this original
formula =VLOOKUP($B4,MasterTab!$H$21:$O$923,8,FALSE)

Thanks,

Steve