Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Hi. i have a workbook with multiple worksheets and some of them contain
matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Post your formula(s) for comments
-- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Hi Daniel,
Please try the below lookup =VLOOKUP(B1,Sheet1!$A$1:$B$23,2,FALSE) in sheet b or sheet 2 in column c1 "Daniel" wrote: Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
the formula i tried
=VLOOKUP(A12,'08.19'!A6:H75,8,0) "Don Guillett" wrote: Post your formula(s) for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
i still get N/A when using absolute look up range.
"Don Guillett" wrote: Maybe not numbers? Sub fixmynums() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(C) End If Next Application.ScreenUpdating = True End Sub =============== Maybe make lookup range absolute =VLOOKUP(A12,'08.19'!$A$6:$H$75,8,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... the formula i tried =VLOOKUP(A12,'08.19'!A6:H75,8,0) "Don Guillett" wrote: Post your formula(s) for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
oh and yes, the values are not exclusively numbers, some are numbers and
letters "Don Guillett" wrote: Maybe not numbers? Sub fixmynums() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(C) End If Next Application.ScreenUpdating = True End Sub =============== Maybe make lookup range absolute =VLOOKUP(A12,'08.19'!$A$6:$H$75,8,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... the formula i tried =VLOOKUP(A12,'08.19'!A6:H75,8,0) "Don Guillett" wrote: Post your formula(s) for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
Post a sample or send your workbook to my address below along with snippets of these msgs. -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... oh and yes, the values are not exclusively numbers, some are numbers and letters "Don Guillett" wrote: Maybe not numbers? Sub fixmynums() Application.ScreenUpdating = False On Error Resume Next For Each C In Selection If Trim(Len(C)) 0 And C.HasFormula = False Then C.NumberFormat = "General" C.Value = CDbl(C) End If Next Application.ScreenUpdating = True End Sub =============== Maybe make lookup range absolute =VLOOKUP(A12,'08.19'!$A$6:$H$75,8,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... the formula i tried =VLOOKUP(A12,'08.19'!A6:H75,8,0) "Don Guillett" wrote: Post your formula(s) for comments -- Don Guillett Microsoft MVP Excel SalesAid Software "Daniel" wrote in message ... Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
=MATCH(B3,'ACTIVE COMM CUSTOMERS'!$A:$A,0) this may seem really basic, but i did the same thing and it worked great In an active worksheet, I ran a column next to the data I was comparing (B3) in this case. Then in MATCH, used the array from a different worksheet, and the column A. After dragging the formula down the entire B column (30000 rows), I sorted. Two results. If there was a MATCH, it gave me the LOCATION of the matching field, and if there was no match, I knew I was missing data from the other worksheet. Hope this helps.. it's really easy and you can do it on the fly without using VLOOKUP "Daniel" wrote: Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup question
i tried to apply the below, but no luck. what i dont understand is that out
of say a 100 lines, 4-5 will do work and it does bring up the relevant field from worksheet B, but i get N/A for the rest. "venumadhav g" wrote: Hi Daniel, Please try the below lookup =VLOOKUP(B1,Sheet1!$A$1:$B$23,2,FALSE) in sheet b or sheet 2 in column c1 "Daniel" wrote: Hi. i have a workbook with multiple worksheets and some of them contain matching data. say, i have worksheet A where i have numbers in column 1, and i have worksheet B where i have numbers in column 1 (some of them matching the ones in worksheet A), and have Comments in column 2. i want to pull up the comments in worksheet A where column 1 has matching data to worksheet B column 1. i tried a simple Vlookup but i always get N/A. hope this makes sense. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP question | Excel Discussion (Misc queries) | |||
vlookup question | Excel Discussion (Misc queries) | |||
VLOOKUP Question | Excel Discussion (Misc queries) | |||
If/And/Vlookup question | Excel Discussion (Misc queries) | |||
vlookup question | Excel Worksheet Functions |