Compare two lists in Excel 2007 with @VLOOKUP
Preview
|
Full size
Buy lesson
Buy lesson
(only $0.99) |
You Might Also Like
-
Capturing, editing and saving a screen snapshot -
Really Simple Bookkeeping Lesson 4: Agree the Bank -
Really Simple Bookkeeping Lesson 3: Money -
Really Simple Bookkeeping Lesson 2: Purchases List -
Really Simple Bookkeeping Lesson 1: Sales List -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Export TB to Excel -
Create a simple macro in Excel 2007
-
Create a simple macro in Excel 2007 -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Checking the Closing VAT -
Really Simple Bookkeeping Lesson 1: Sales List -
Really Simple Bookkeeping Lesson 2: Purchases List -
Really Simple Bookkeeping Lesson 3: Money -
Really Simple Bookkeeping Lesson 4: Agree the Bank -
Capturing, editing and saving a screen snapshot -
Really Simple Bookkeeping Lesson 1: Sales List -
Sage 50 / Instant: Year end date -
Sage 50 / Instant: Check VAT on Closing Debtors -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Checking Opening Balances -
Create a simple macro in Excel 2007
-
Create a simple macro in Excel 2007 -
Sage 50 / Instant: Checking Opening Balances -
Sage 50 / Instant: Debtors and Creditors -
Sage 50 / Instant: Export TB to Excel -
Sage 50 / Instant: Be a Detective - Find Mistakes -
Sage 50 / Instant: Nominal Activity for >1 Codes -
Sage 50 / Instant: Checking the Closing VAT -
Sage 50 / Instant: Check VAT on Closing Debtors -
Sage 50 / Instant: Year end date -
Really Simple Bookkeeping Lesson 1: Sales List
About this Lesson
- Type: Video Tutorial
- Length: 2:27
- Media: Video/mp4
- Posted: 05/07/2009
- Use: Watch Online & Download
- Download: MP4
- Size: 4 MB
How do you compare two lists in Excel 2007?
Do you have to print one out, look at the other on screen, and tick them off one by one?
No fear - with a simple @VLOOKUP formula you can quickly and easily add data from one list to the other. And you don't need to be an Excel whizz to do that!
This video gives clear step-by-step instructions to help you LOOKUP like a pro.
About this Author
-
- Emily Coltman
- 15 lessons
- Joined:
05/07/2009
Hi, I'm a Chartered Accountant by profession and have now branched out into making screencasts.
My "Sage Tricks for Accountants" video series came about after having learnt these tricks the hard way as I struggled to turn a set of records on Sage into a set of balancing accounts.
And my "Really Simple Bookkeeping" video series was inspired by the number of really small businesses who just don't need to buy expensive desktop software to keep their books.
More..Recent Reviews
This lesson has not been reviewed.
Please purchase the lesson to review.
Recent Comments
This lesson has not been reviewed.
Please purchase the lesson to review.
Buy Now and Start Learning
CommunityMore
- Painting with Acrylics: Layering Te...
-
- I am taking a class from Polly right now, and this lesson is a great way for me to unde...
- Trigonometry: Trig Function Composi...
-
- great explanation of trig function composition and inverse trig functions.
- Flower painting 1-Water Color Pencils
-
- Excellent, easy to follow instruction.
- I want to learn how to build a slid...
-
- I want to learn how to build a slideboard
- compound subjects and predicates
-
- compound subjects and predicates
- I want to learn Trigonometry
-
- I want to learn Trigonometry
Embed this video on your site
Copy and paste the following snippet:
Link to this page
Copy and paste the following snippet:
