Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New to VLOOKUP function
I am new to the VLOOKUP function and I am told that it can do this.
I need to compare two columns of data and find what is new in one of the columns. The data is in two separate workbooks, although I could put them in one workbook if it will facilitate the formula. So for instance, in workbook (WB) 1, I have a column for customer number with a bunch of data and in WB2, I have a column for customer number with a bunch of data. I just want to compare the two customer number columns to each other and find any new customer numbers added in WB2 that are not in WB1 for instance. I tried and couldn't get the formula to work. Thanks, -- Kathy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New to VLOOKUP function
Never mind, I figured it out after playing with it awhile longer.
Never did like VLOOKUP's..... -- Kathy "Kathy" wrote: I am new to the VLOOKUP function and I am told that it can do this. I need to compare two columns of data and find what is new in one of the columns. The data is in two separate workbooks, although I could put them in one workbook if it will facilitate the formula. So for instance, in workbook (WB) 1, I have a column for customer number with a bunch of data and in WB2, I have a column for customer number with a bunch of data. I just want to compare the two customer number columns to each other and find any new customer numbers added in WB2 that are not in WB1 for instance. I tried and couldn't get the formula to work. Thanks, -- Kathy |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
New to VLOOKUP function
Try something like this:
In WB2 assume customer numbers are in the range Sheet1 A1:A10. In WB1 assume customer numbers are in the range Sheet1 A1:A10. In WB2 Sheet1 enter this formula in B1. A result of "X" means the customer number *is not* in WB1. =IF(COUNT(MATCH(A1,[WB1.xls]Sheet1!$A$1:$A$10,0)),"","X") -- Biff Microsoft Excel MVP "Kathy" wrote in message ... I am new to the VLOOKUP function and I am told that it can do this. I need to compare two columns of data and find what is new in one of the columns. The data is in two separate workbooks, although I could put them in one workbook if it will facilitate the formula. So for instance, in workbook (WB) 1, I have a column for customer number with a bunch of data and in WB2, I have a column for customer number with a bunch of data. I just want to compare the two customer number columns to each other and find any new customer numbers added in WB2 that are not in WB1 for instance. I tried and couldn't get the formula to work. Thanks, -- Kathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Embedded VLOOKUP function within IF function | Excel Worksheet Functions | |||
HOW DO I NEST THE VLOOKUP FUNCTION WITH THE LEFT FUNCTION | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
I want to use Vlookup function and AND function in a single formu. | Excel Worksheet Functions |