Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Excel lookups

Comment:

Hi, I have 2 spreadsheets with names of users, I need to find out if users on spreadsheet 1 are duplicated on spreadsheet 2, I have tried vlookup but can't get it to work. Can someone help? Thanks

Name: chnos
Date: March 21, 2005 at 09:50:27 Pacific

Reply:

pivot table based on both sheets.

0

Visual Basic Delete a Fil...

Outlook 2003

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Thank you for quick response and sorry for my English it could be better. b) I have a table with 8 columns and 20 rows. As I said in the leftmost column i.e. column one I have values 1,2,3,… 20 down...

Summary: I have a spreadsheet that has a list something like this.... A B C D E 1 Rej. Amount 2 bot 23 3 top 54 4 sid 10 5 bot 24 6 bot 12 7 sid 10...

Summary: There is no built-in Excel function to do what you want, but someone has written some VBA code that might work. Go here: http://www.contextures.com/excelfil... and check out the 5th example under Data...