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?

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?

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?

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?

Vlookup question
 

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?

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?

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?

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?

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?

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?