Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

formula

ResolvedVersion 2002/XP

Sarah has attended:
Excel Intermediate course

Formula

Have you got a formula for comparing two lists of values?

RE: Formula

Hello Sarah
Thank you for your question

This depends on how you are trying to compare them, but you could try VLOOKUP. Highlight the first list and name it as range 1, ensuring that the first column is the column you want to compare. Then use the vlookup formula to see if values in your list are present in your other list.


If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Thu 19 Mar 2009: Automatically marked as resolved.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.