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!

On Jan 8, 3:56 pm, Southern at Heart
<SouthernatHe...@discussions.microsoft.com> 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.