lookup in two worksheets

  • Thread starter Thread starter Dee
  • Start date Start date
D

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?
 
In a cell U1 in sheet 2 use something like =VLOOKUP(<number>,!Sheet1$A:$F,6).
Let me know if it helped.
 
Back
Top