Vlookup

Closed

Jay - Aug 10, 2010 at 05:55 AM
Trowa - Aug 10, 2010 at 09:08 AM

Hello,

Im using excel 03.

Quick question if anyone can help, I have to sets of lists in column A and Column B. the basic prinicple is I have done some testing and found differences between the two columns ideally both columns should have the same data but infact they dont. in my case column B has an additional 23 pieces of data and i need to know how to use a vlookup to check what is in column A and B and what is missing from column B.

any help guys, pls??

Vlookup
Transfer data from one excel worksheet to another automatically vlookup - Guide
Vlookup if two cells match return value from third ✓ - Excel Forum
Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
Vba to auto insert comment (by vlookup list) on cell data entry - Excel Forum

1 response

Answer 1 / 1

Trowa
Aug 10, 2010 at 09:08 AM

It is easier to help when you give an example of how your sheet looks like and how you would like your sheet to look like.

Similar discussions

Match partial text string in one sheet to another text string in another sheet

Using Vlookup to return insted of 00/01/1900

Concanating text using vlookup forumula

Conditional Formatting in a vlookup

Find missing data in 2 columns (Excel)

Similar discussions

Subscribe To Our Newsletter!