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?