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