lookup in two worksheets

[Dee]

I have two worksheets.

I want to locate a file number in column A of worksheet one

Then locate the "Lessor" in column F ( that is in the same row as file
number)

Copy "Lessor" info from respective cell

Then go to worksheet two and paste "Lessor" info in Column U (both
column U from worksheet 2 and Column F from worksheet 1 are titled
Lessor)

Is there a formula to do this?

 

[Robert]

In a cell U1 in sheet 2 use something like =VLOOKUP(<number>,!Sheet1$A:$F,6).
Let me know if it helped.

 

[Fred Smith]

I'm sure Robert meant:
=VLOOKUP(<number>,Sheet1!$A:$F,6)

Regards,
Fred