Vlookup to show value from 2 colums

It would work a little something like this:

Formula:

=IF(VLOOKUP1=0,VLOOKUP2,VLOOKUP1)

However, as your first VLOOKUP is only returning a value from the 1st column in a range, if it doesn't find the value then I imagine you get an error, so potentially you could use:

Formula:

=IFERROR(VLOOKUP1,VLOOKUP2)

BSB