I need help matching spreadsheets

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.
 
B

B. R.Ramachandran

Hi,

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

B. R. Ramachandran
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help with matching spreadsheets 1
Identify files on two diff spreadsheets 1
Need VLOOKUP to Work Two Ways 0
HLookup help 1
comparing columns in two spreadsheets 1
matching and entering data 3
VLOOKUP Help 1
VLookup multiple spreadsheets 2

Top