View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default I need help matching spreadsheets

Please help.

I have two spreadhseets with file numbers in column A, but a bunch of
additional data in the other columns. I need to know if the files on sheet 2
(smaller data set, named "RS") are on sheet 1 (larger data set, named
"2008"). If so, I need it to produce a "1" on sheet 1, column "U".

I've tried vlookup, but couldn't quite figure it out.

Thank you.