I have 2 tables - Refmam1 and Refman2

My lookup value is in ColA. I Want to return the value in ColB

Is it possible to use the vlookup so that it checks Refman1 and Refman2 ?

Thank you in advance.