Vlookup to show value from 2 colums

Hello all,
Trying to use a Vlookup to get information brought over from 2 different columns. Basically real quick i want to extract the cell that has the first available value
If lookup value 1 is blank, then I want the lookup to show the value that is in lookup value 2
And if the value is in lookup value 1, i don't want it to pull in lookup value 2.

=vlookup(a7,'sheet1'A:B,1,false),vlookup(a7,'sheet1'A:B,2,false) )


How do i make this work properly..

Thanks

=if(vlookup(a7,'sheet1'A:B,1,false)=1,vlookup(a7,'sheet1'A:B,1,false),vlookup(a7,'sheet1'A:B,2,false) )

It would work a little something like this:

Formula:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

BSB

sorry =if(vlookup(a7,'sheet1'A:B,1,false)<>"",vlookup(a7,'sheet1'A:B,1,false),vlookup(a7,'sheet1'A:B,2,false) )

Perfect CRIMEDOG. Thanks for the assist