I need to use the lookup function.

Spreadsheet A looks like this Spreadsheet B

1 Now is the time for 1 Now is not the time
2 Ask Not What Your 2 Ask Not What Your
3 Where Did Mary Go 3 Where Did Mary Go
4 All Good Boys Did Fine 4 All the Boys Are Back in

I want to place and use this formula in Spreadsheet B to lookup if what's in
Spreadsheet B exists in spreadsheet A, then populate
new column new spreadsheet with results (that is the matching data). In
this case should be rows 2 and 3 only that matches Spreadsheet A. And I
don't understand the formula.

HELP HELP HELP HELP !! I'm sinking fast ----- Deadline approaches.....

=LOOKUP(B1,[SpreadsheetA.xls]DELIVERY_149!$F:$F,[SpreadsheetA.xls]DELIVERY_149!$G:$G)