Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookUp in Excel
I'm trying to complete a simple comparison of two columns of asset #s
and locate any missing numbers from the smaller of the two. I'm getting errors everytime I try. Any help you can provide? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookUp in Excel
Let's assume the data you are checking is in column A of Sheet 1 and the data
you are checking it against is in column A of Sheet 2. Try something like this =VLOOKUP(Sheet1!A1,Sheet2!$A$1:$A$100,1,FALSE) If there is a match, this will return the matched value. Also note that there needs to be an exact match for you to get a returned value. If there is no exact match, you'll see #N/A. " wrote: I'm trying to complete a simple comparison of two columns of asset #s and locate any missing numbers from the smaller of the two. I'm getting errors everytime I try. Any help you can provide? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookUp in Excel
On May 5, 6:08 am, Barb Reinhardt
wrote: Let's assume the data you are checking is in column A of Sheet 1 and the data you are checking it against is in column A of Sheet 2. Try something like this =VLOOKUP(Sheet1!A1,Sheet2!$A$1:$A$100,1,FALSE) If there is a match, this will return the matched value. Also note that there needs to be an exact match for you to get a returned value. If there is no exact match, you'll see #N/A. " wrote: I'm trying to complete a simple comparison oftwocolumnsof asset #s and locate anymissingnumbersfrom the smaller of thetwo. I'm getting errors everytime I try. Any help you can provide?- Hide quoted text - - Show quoted text - Thanks for the input. I completed and had this formula: =VLOOKUP(C2,'redc 5-4-7.xls'!$I$2:$I $106,2,FALSE). The VLookUp is supposed to compare all the Numbers from Colum C on my first sheet to the colum that I specifed on the second sheet ('redc 5-4-7.xls'!$I$2:$I$106). I then created another column in the first worksheet, colum 2 to return the results to. I only came back with one match? It may be easier if I explain what I am doing. I know that I have 95 specific numbers on the fist sheet. I only have 94 of those 95 on the second sheet. How do I find the missing number, is the question? While 95 is not that difficult to go through and sort, then cut and paste the two next to each other and maually compare, when I get hundreds of numbers to compare and notice that I am missing 5 out of say 500, then this becomes a time consuming issue. Shouldn't this VLookUp be searching the first number in Column C with all of the numbers in the Column on sheet two that I specificed and then populate the number I'm searching for in the new column I've made( if there is a match)? The formula continues for the second number and so forth? The two columns I'm comparing don't have to be in numerical order, do they? Sorry for all the questions, I've seen this formula work and when it does, it works well....just need some direction. Thank you. |
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) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Using Vlookup in Excel | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |