I need help matching spreadsheets

  • Thread starter Thread starter JoeL
  • Start date Start date
J

JoeL

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.
 
Hi,

See my response to your post "VLOOKUP Help" in the "Excel General Questions"
group.

B. R. Ramachandran
 
Back
Top