Another lookup question
 

I got great help the last time, and here's an easier question:
I have 2 sheets, sheet1 and sheet2, both are like a database, with the first
column containing the ID Key that links them.
I need sheet1:column B to refence column F on sheet2, using the relationship
from sheet1:A to sheet2:A
thanks!

Another lookup question
 

On Jan 8, 3:56 pm, Southern at Heart
wrote:
I got great help the last time, and here's an easier question:
I have 2 sheets, sheet1 and sheet2, both are like a database, with the first
column containing the ID Key that links them.
I need sheet1:column B to refence column F on sheet2, using the relationship
from sheet1:A to sheet2:A
thanks!

=VLOOKUP(A2,Sheet2!$A$2:$F$1000,6)

Assuming there is a header row in both sheets and that you have 999
rows of data in sheet 2.