Populating Information from two cells into one cell on another tab

Hello... Im trying to set up something where once the serial # is typed in on the second sheet..it populates all the information from the table that is on sheet 1.. However there are two columns that one may have a value but the other doesnt..either way one or the other will have a value..never both..I want to be able to put that information from sheet 1 onto one column on sheet 2.

So once i punch in a serial number I want it to populate the RMA# either from Column RMA# First or if not a value there then populate from RMA# Second onto one column on my other table along with Type, Part #, Description, etc..

Table 1
Table 1.png

Table 2 this is where they'll type serial # and it will populate everything.
Table 2.png

Any help would be appreciated!

I can do it in Jpeg form if that helps..

Table 1
Table 1.jpg

Table 2
Table 2.jpg

Work Book.xlsx
Sorry there ya go.. So the second table is where they'll enter the serial number in the blank part and the
rest will populate From Sheet 1 Table.

See if this might do what you are wanting:

Part Lookup.xlsx

BTW I added data validation to the serial number column on sheet two.

Works well! Thanks a lot guys!

Thanks for the feedback, if the solution(s) are satisfactory, please mark the thread [Solved].