software

I'm having trouble using the lookup function.

I have numbers that look like this in a list, although it's only part of
what I'm using:

-112179
-102420
-92661
-82897
-73123
-63332
-53521
-43683
-33814
-23910
-13970
03989
13970
23910
33814
43683
53521
63332
73123
82897
92661
102420
112179

When I use the lookup function on another sheet of the cell, it does not
look up the proper value always. My columns go from (-100, 100). Outside
the values of (-10,10), the lookup works properly.

These are the lookup cells:

-112179
-102420
-92420
-82897
-73123
-63332
-53521
-43521
-33814
-23814
-13910
03989
13989
23910
33910
43683
53521
63521
73123
83123
92661
102420
112179

If you'll notice, the values that the lookup cells get are not the values of
the cell they're looking up, but often one off.

Any suggestions on why this might be happening?

What is your lookup equation?

quot;Blackbirdquot; gt; wrote in message
...
gt; I'm having trouble using the lookup function.
gt;
gt; I have numbers that look like this in a list, although it's only part of
gt; what I'm using:
gt;
gt; -11 2179
gt; -10 2420
gt; -9 2661
gt; -8 2897
gt; -7 3123
gt; -6 3332
gt; -5 3521
gt; -4 3683
gt; -3 3814
gt; -2 3910
gt; -1 3970
gt; 0 3989
gt; 1 3970
gt; 2 3910
gt; 3 3814
gt; 4 3683
gt; 5 3521
gt; 6 3332
gt; 7 3123
gt; 8 2897
gt; 9 2661
gt; 10 2420
gt; 11 2179
gt;
gt; When I use the lookup function on another sheet of the cell, it does not
gt; look up the proper value always. My columns go from (-100, 100). Outside
gt; the values of (-10,10), the lookup works properly.
gt;
gt; These are the lookup cells:
gt;
gt; -11 2179
gt; -10 2420
gt; -9 2420
gt; -8 2897
gt; -7 3123
gt; -6 3332
gt; -5 3521
gt; -4 3521
gt; -3 3814
gt; -2 3814
gt; -1 3910
gt; 0 3989
gt; 1 3989
gt; 2 3910
gt; 3 3910
gt; 4 3683
gt; 5 3521
gt; 6 3521
gt; 7 3123
gt; 8 3123
gt; 9 2661
gt; 10 2420
gt; 11 2179
gt;
gt; If you'll notice, the values that the lookup cells get are not the values
gt; of
gt; the cell they're looking up, but often one off.
gt;
gt; Any suggestions on why this might be happening?
For instance, the equation for the cell that is to the right of zero is
quot;=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)quot;

quot;Barb Reinhardtquot; wrote:

gt; What is your lookup equation?
gt;
gt; quot;Blackbirdquot; gt; wrote in message
gt; ...
gt; gt; I'm having trouble using the lookup function.
gt; gt;
gt; gt; I have numbers that look like this in a list, although it's only part of
gt; gt; what I'm using:
gt; gt;
gt; gt; -11 2179
gt; gt; -10 2420
gt; gt; -9 2661
gt; gt; -8 2897
gt; gt; -7 3123
gt; gt; -6 3332
gt; gt; -5 3521
gt; gt; -4 3683
gt; gt; -3 3814
gt; gt; -2 3910
gt; gt; -1 3970
gt; gt; 0 3989
gt; gt; 1 3970
gt; gt; 2 3910
gt; gt; 3 3814
gt; gt; 4 3683
gt; gt; 5 3521
gt; gt; 6 3332
gt; gt; 7 3123
gt; gt; 8 2897
gt; gt; 9 2661
gt; gt; 10 2420
gt; gt; 11 2179
gt; gt;
gt; gt; When I use the lookup function on another sheet of the cell, it does not
gt; gt; look up the proper value always. My columns go from (-100, 100). Outside
gt; gt; the values of (-10,10), the lookup works properly.
gt; gt;
gt; gt; These are the lookup cells:
gt; gt;
gt; gt; -11 2179
gt; gt; -10 2420
gt; gt; -9 2420
gt; gt; -8 2897
gt; gt; -7 3123
gt; gt; -6 3332
gt; gt; -5 3521
gt; gt; -4 3521
gt; gt; -3 3814
gt; gt; -2 3814
gt; gt; -1 3910
gt; gt; 0 3989
gt; gt; 1 3989
gt; gt; 2 3910
gt; gt; 3 3910
gt; gt; 4 3683
gt; gt; 5 3521
gt; gt; 6 3521
gt; gt; 7 3123
gt; gt; 8 3123
gt; gt; 9 2661
gt; gt; 10 2420
gt; gt; 11 2179
gt; gt;
gt; gt; If you'll notice, the values that the lookup cells get are not the values
gt; gt; of
gt; gt; the cell they're looking up, but often one off.
gt; gt;
gt; gt; Any suggestions on why this might be happening?
gt;
gt;
gt;

If you are looking for an exact match use vlookup or index and match combo

=VLOOKUP(A104,'Issue 1'!E2:H102,4,0)

or

=INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0))

--
Regards,

Peo Sjoblom

(No private emails please)quot;Blackbirdquot; gt; wrote in message
...
gt; For instance, the equation for the cell that is to the right of zero is
gt; quot;=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)quot;
gt;
gt; quot;Barb Reinhardtquot; wrote:
gt;
gt;gt; What is your lookup equation?
gt;gt;
gt;gt; quot;Blackbirdquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'm having trouble using the lookup function.
gt;gt; gt;
gt;gt; gt; I have numbers that look like this in a list, although it's only part
gt;gt; gt; of
gt;gt; gt; what I'm using:
gt;gt; gt;
gt;gt; gt; -11 2179
gt;gt; gt; -10 2420
gt;gt; gt; -9 2661
gt;gt; gt; -8 2897
gt;gt; gt; -7 3123
gt;gt; gt; -6 3332
gt;gt; gt; -5 3521
gt;gt; gt; -4 3683
gt;gt; gt; -3 3814
gt;gt; gt; -2 3910
gt;gt; gt; -1 3970
gt;gt; gt; 0 3989
gt;gt; gt; 1 3970
gt;gt; gt; 2 3910
gt;gt; gt; 3 3814
gt;gt; gt; 4 3683
gt;gt; gt; 5 3521
gt;gt; gt; 6 3332
gt;gt; gt; 7 3123
gt;gt; gt; 8 2897
gt;gt; gt; 9 2661
gt;gt; gt; 10 2420
gt;gt; gt; 11 2179
gt;gt; gt;
gt;gt; gt; When I use the lookup function on another sheet of the cell, it does
gt;gt; gt; not
gt;gt; gt; look up the proper value always. My columns go from (-100, 100).
gt;gt; gt; Outside
gt;gt; gt; the values of (-10,10), the lookup works properly.
gt;gt; gt;
gt;gt; gt; These are the lookup cells:
gt;gt; gt;
gt;gt; gt; -11 2179
gt;gt; gt; -10 2420
gt;gt; gt; -9 2420
gt;gt; gt; -8 2897
gt;gt; gt; -7 3123
gt;gt; gt; -6 3332
gt;gt; gt; -5 3521
gt;gt; gt; -4 3521
gt;gt; gt; -3 3814
gt;gt; gt; -2 3814
gt;gt; gt; -1 3910
gt;gt; gt; 0 3989
gt;gt; gt; 1 3989
gt;gt; gt; 2 3910
gt;gt; gt; 3 3910
gt;gt; gt; 4 3683
gt;gt; gt; 5 3521
gt;gt; gt; 6 3521
gt;gt; gt; 7 3123
gt;gt; gt; 8 3123
gt;gt; gt; 9 2661
gt;gt; gt; 10 2420
gt;gt; gt; 11 2179
gt;gt; gt;
gt;gt; gt; If you'll notice, the values that the lookup cells get are not the
gt;gt; gt; values
gt;gt; gt; of
gt;gt; gt; the cell they're looking up, but often one off.
gt;gt; gt;
gt;gt; gt; Any suggestions on why this might be happening?
gt;gt;
gt;gt;
gt;gt;For some reason, neither suggestion gives values all the time now.

Often, I get the #N/A error. However, there most definitely is a value
among the series the corresponds, so there shouldn't be an #N/A error.

quot;Peo Sjoblomquot; wrote:

gt; If you are looking for an exact match use vlookup or index and match combo
gt;
gt; =VLOOKUP(A104,'Issue 1'!E2:H102,4,0)
gt;
gt; or
gt;
gt; =INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0))
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Blackbirdquot; gt; wrote in message
gt; ...
gt; gt; For instance, the equation for the cell that is to the right of zero is
gt; gt; quot;=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)quot;
gt; gt;
gt; gt; quot;Barb Reinhardtquot; wrote:
gt; gt;
gt; gt;gt; What is your lookup equation?
gt; gt;gt;
gt; gt;gt; quot;Blackbirdquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; I'm having trouble using the lookup function.
gt; gt;gt; gt;
gt; gt;gt; gt; I have numbers that look like this in a list, although it's only part
gt; gt;gt; gt; of
gt; gt;gt; gt; what I'm using:
gt; gt;gt; gt;
gt; gt;gt; gt; -11 2179
gt; gt;gt; gt; -10 2420
gt; gt;gt; gt; -9 2661
gt; gt;gt; gt; -8 2897
gt; gt;gt; gt; -7 3123
gt; gt;gt; gt; -6 3332
gt; gt;gt; gt; -5 3521
gt; gt;gt; gt; -4 3683
gt; gt;gt; gt; -3 3814
gt; gt;gt; gt; -2 3910
gt; gt;gt; gt; -1 3970
gt; gt;gt; gt; 0 3989
gt; gt;gt; gt; 1 3970
gt; gt;gt; gt; 2 3910
gt; gt;gt; gt; 3 3814
gt; gt;gt; gt; 4 3683
gt; gt;gt; gt; 5 3521
gt; gt;gt; gt; 6 3332
gt; gt;gt; gt; 7 3123
gt; gt;gt; gt; 8 2897
gt; gt;gt; gt; 9 2661
gt; gt;gt; gt; 10 2420
gt; gt;gt; gt; 11 2179
gt; gt;gt; gt;
gt; gt;gt; gt; When I use the lookup function on another sheet of the cell, it does
gt; gt;gt; gt; not
gt; gt;gt; gt; look up the proper value always. My columns go from (-100, 100).
gt; gt;gt; gt; Outside
gt; gt;gt; gt; the values of (-10,10), the lookup works properly.
gt; gt;gt; gt;
gt; gt;gt; gt; These are the lookup cells:
gt; gt;gt; gt;
gt; gt;gt; gt; -11 2179
gt; gt;gt; gt; -10 2420
gt; gt;gt; gt; -9 2420
gt; gt;gt; gt; -8 2897
gt; gt;gt; gt; -7 3123
gt; gt;gt; gt; -6 3332
gt; gt;gt; gt; -5 3521
gt; gt;gt; gt; -4 3521
gt; gt;gt; gt; -3 3814
gt; gt;gt; gt; -2 3814
gt; gt;gt; gt; -1 3910
gt; gt;gt; gt; 0 3989
gt; gt;gt; gt; 1 3989
gt; gt;gt; gt; 2 3910
gt; gt;gt; gt; 3 3910
gt; gt;gt; gt; 4 3683
gt; gt;gt; gt; 5 3521
gt; gt;gt; gt; 6 3521
gt; gt;gt; gt; 7 3123
gt; gt;gt; gt; 8 3123
gt; gt;gt; gt; 9 2661
gt; gt;gt; gt; 10 2420
gt; gt;gt; gt; 11 2179
gt; gt;gt; gt;
gt; gt;gt; gt; If you'll notice, the values that the lookup cells get are not the
gt; gt;gt; gt; values
gt; gt;gt; gt; of
gt; gt;gt; gt; the cell they're looking up, but often one off.
gt; gt;gt; gt;
gt; gt;gt; gt; Any suggestions on why this might be happening?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;

Did you import this? If so you might have hidden spaces trailing html
characters, I just make a quick test and copied the table for your post,
pasted into excel and applied a vlookup formula typing in the lookup values
and those that I tried I got a correct hit, no errors at all so I can only
assume that what you think is a match is not,
you can test with a cell that you know should be correct and then compare
them =cell=cell2 or even check how many characters

=LEN(lookup_Value_cell)
=LEN(value_from Table_cell)

same number?

--
Regards,

Peo Sjoblom

(No private emails please)quot;Blackbirdquot; gt; wrote in message
...
gt; For some reason, neither suggestion gives values all the time now.
gt;
gt; Often, I get the #N/A error. However, there most definitely is a value
gt; among the series the corresponds, so there shouldn't be an #N/A error.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; If you are looking for an exact match use vlookup or index and match
gt;gt; combo
gt;gt;
gt;gt; =VLOOKUP(A104,'Issue 1'!E2:H102,4,0)
gt;gt;
gt;gt; or
gt;gt;
gt;gt; =INDEX('Issue 1'!H2:H102,MATCH(A104,'Issue 1'!E2:E102,0))
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; (No private emails please)
gt;gt;
gt;gt;
gt;gt; quot;Blackbirdquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; For instance, the equation for the cell that is to the right of zero is
gt;gt; gt; quot;=LOOKUP(A104, 'Issue 1'!$E$2:$E$102, 'Issue 1'!$H$2:$H$102)quot;
gt;gt; gt;
gt;gt; gt; quot;Barb Reinhardtquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; What is your lookup equation?
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Blackbirdquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; I'm having trouble using the lookup function.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I have numbers that look like this in a list, although it's only
gt;gt; gt;gt; gt; part
gt;gt; gt;gt; gt; of
gt;gt; gt;gt; gt; what I'm using:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; -11 2179
gt;gt; gt;gt; gt; -10 2420
gt;gt; gt;gt; gt; -9 2661
gt;gt; gt;gt; gt; -8 2897
gt;gt; gt;gt; gt; -7 3123
gt;gt; gt;gt; gt; -6 3332
gt;gt; gt;gt; gt; -5 3521
gt;gt; gt;gt; gt; -4 3683
gt;gt; gt;gt; gt; -3 3814
gt;gt; gt;gt; gt; -2 3910
gt;gt; gt;gt; gt; -1 3970
gt;gt; gt;gt; gt; 0 3989
gt;gt; gt;gt; gt; 1 3970
gt;gt; gt;gt; gt; 2 3910
gt;gt; gt;gt; gt; 3 3814
gt;gt; gt;gt; gt; 4 3683
gt;gt; gt;gt; gt; 5 3521
gt;gt; gt;gt; gt; 6 3332
gt;gt; gt;gt; gt; 7 3123
gt;gt; gt;gt; gt; 8 2897
gt;gt; gt;gt; gt; 9 2661
gt;gt; gt;gt; gt; 10 2420
gt;gt; gt;gt; gt; 11 2179
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; When I use the lookup function on another sheet of the cell, it does
gt;gt; gt;gt; gt; not
gt;gt; gt;gt; gt; look up the proper value always. My columns go from (-100, 100).
gt;gt; gt;gt; gt; Outside
gt;gt; gt;gt; gt; the values of (-10,10), the lookup works properly.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; These are the lookup cells:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; -11 2179
gt;gt; gt;gt; gt; -10 2420
gt;gt; gt;gt; gt; -9 2420
gt;gt; gt;gt; gt; -8 2897
gt;gt; gt;gt; gt; -7 3123
gt;gt; gt;gt; gt; -6 3332
gt;gt; gt;gt; gt; -5 3521
gt;gt; gt;gt; gt; -4 3521
gt;gt; gt;gt; gt; -3 3814
gt;gt; gt;gt; gt; -2 3814
gt;gt; gt;gt; gt; -1 3910
gt;gt; gt;gt; gt; 0 3989
gt;gt; gt;gt; gt; 1 3989
gt;gt; gt;gt; gt; 2 3910
gt;gt; gt;gt; gt; 3 3910
gt;gt; gt;gt; gt; 4 3683
gt;gt; gt;gt; gt; 5 3521
gt;gt; gt;gt; gt; 6 3521
gt;gt; gt;gt; gt; 7 3123
gt;gt; gt;gt; gt; 8 3123
gt;gt; gt;gt; gt; 9 2661
gt;gt; gt;gt; gt; 10 2420
gt;gt; gt;gt; gt; 11 2179
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; If you'll notice, the values that the lookup cells get are not the
gt;gt; gt;gt; gt; values
gt;gt; gt;gt; gt; of
gt;gt; gt;gt; gt; the cell they're looking up, but often one off.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Any suggestions on why this might be happening?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;Yes, I did import them.

When I did those tests, they indicated that there numbers were imprecise and
had been rounded for display purposes. I used the ROUND function, and then
they all came up as TRUE when using that test and with equal numbers using
LEN.

Still however, the error persists.

quot;Peo Sjoblomquot; wrote:

gt; Did you import this? If so you might have hidden spaces trailing html
gt; characters, I just make a quick test and copied the table for your post,
gt; pasted into excel and applied a vlookup formula typing in the lookup values
gt; and those that I tried I got a correct hit, no errors at all so I can only
gt; assume that what you think is a match is not,
gt; you can test with a cell that you know should be correct and then compare
gt; them =cell=cell2 or even check how many characters
gt;
gt; =LEN(lookup_Value_cell)
gt; =LEN(value_from Table_cell)
gt;
gt; same number?
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)

You might need to round in both instances

=INDEX('Issue 1'!H2:H102,MATCH(ROUND(A104,2),ROUND('Issue 1'!E2:E102,2),0))

entered with ctrl shift amp; enter

other than that one value might be text and the other number, try this

=ISTEXT('Issue 1'!E2)

copy down and see if you get any true values, do the same with your lookup
values

--
Regards,

Peo Sjoblom

(No private emails please)quot;Blackbirdquot; gt; wrote in message
...
gt; Yes, I did import them.
gt;
gt; When I did those tests, they indicated that there numbers were imprecise
gt; and
gt; had been rounded for display purposes. I used the ROUND function, and
gt; then
gt; they all came up as TRUE when using that test and with equal numbers using
gt; LEN.
gt;
gt; Still however, the error persists.
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Did you import this? If so you might have hidden spaces trailing html
gt;gt; characters, I just make a quick test and copied the table for your post,
gt;gt; pasted into excel and applied a vlookup formula typing in the lookup
gt;gt; values
gt;gt; and those that I tried I got a correct hit, no errors at all so I can
gt;gt; only
gt;gt; assume that what you think is a match is not,
gt;gt; you can test with a cell that you know should be correct and then compare
gt;gt; them =cell=cell2 or even check how many characters
gt;gt;
gt;gt; =LEN(lookup_Value_cell)
gt;gt; =LEN(value_from Table_cell)
gt;gt;
gt;gt; same number?
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; (No private emails please)I get false on both instances when I use ISTEXT on every value.

The index function yields #VALUE. Perhaps I don't know exactly how to work
it?

Should I send you my actual file?

quot;Peo Sjoblomquot; wrote:

gt; You might need to round in both instances
gt;
gt; =INDEX('Issue 1'!H2:H102,MATCH(ROUND(A104,2),ROUND('Issue 1'!E2:E102,2),0))
gt;
gt; entered with ctrl shift amp; enter
gt;
gt; other than that one value might be text and the other number, try this
gt;
gt; =ISTEXT('Issue 1'!E2)
gt;
gt; copy down and see if you get any true values, do the same with your lookup
gt; values
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; (No private emails please)
gt;
gt;
gt; quot;Blackbirdquot; gt; wrote in message
gt; ...
gt; gt; Yes, I did import them.
gt; gt;
gt; gt; When I did those tests, they indicated that there numbers were imprecise
gt; gt; and
gt; gt; had been rounded for display purposes. I used the ROUND function, and
gt; gt; then
gt; gt; they all came up as TRUE when using that test and with equal numbers using
gt; gt; LEN.
gt; gt;
gt; gt; Still however, the error persists.
gt; gt;
gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt;
gt; gt;gt; Did you import this? If so you might have hidden spaces trailing html
gt; gt;gt; characters, I just make a quick test and copied the table for your post,
gt; gt;gt; pasted into excel and applied a vlookup formula typing in the lookup
gt; gt;gt; values
gt; gt;gt; and those that I tried I got a correct hit, no errors at all so I can
gt; gt;gt; only
gt; gt;gt; assume that what you think is a match is not,
gt; gt;gt; you can test with a cell that you know should be correct and then compare
gt; gt;gt; them =cell=cell2 or even check how many characters
gt; gt;gt;
gt; gt;gt; =LEN(lookup_Value_cell)
gt; gt;gt; =LEN(value_from Table_cell)
gt; gt;gt;
gt; gt;gt; same number?
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; (No private emails please)
gt;
gt;

Somehow, when I use the ROUND function now, it all works. It didn't work
last time, and I still had it in there, but then it started working when I
opened the application again.

Thanks!

quot;Blackbirdquot; wrote:

gt; I get false on both instances when I use ISTEXT on every value.
gt;
gt; The index function yields #VALUE. Perhaps I don't know exactly how to work
gt; it?
gt;
gt; Should I send you my actual file?
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; You might need to round in both instances
gt; gt;
gt; gt; =INDEX('Issue 1'!H2:H102,MATCH(ROUND(A104,2),ROUND('Issue 1'!E2:E102,2),0))
gt; gt;
gt; gt; entered with ctrl shift amp; enter
gt; gt;
gt; gt; other than that one value might be text and the other number, try this
gt; gt;
gt; gt; =ISTEXT('Issue 1'!E2)
gt; gt;
gt; gt; copy down and see if you get any true values, do the same with your lookup
gt; gt; values
gt; gt;
gt; gt; --
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; (No private emails please)
gt; gt;
gt; gt;
gt; gt; quot;Blackbirdquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; Yes, I did import them.
gt; gt; gt;
gt; gt; gt; When I did those tests, they indicated that there numbers were imprecise
gt; gt; gt; and
gt; gt; gt; had been rounded for display purposes. I used the ROUND function, and
gt; gt; gt; then
gt; gt; gt; they all came up as TRUE when using that test and with equal numbers using
gt; gt; gt; LEN.
gt; gt; gt;
gt; gt; gt; Still however, the error persists.
gt; gt; gt;
gt; gt; gt; quot;Peo Sjoblomquot; wrote:
gt; gt; gt;
gt; gt; gt;gt; Did you import this? If so you might have hidden spaces trailing html
gt; gt; gt;gt; characters, I just make a quick test and copied the table for your post,
gt; gt; gt;gt; pasted into excel and applied a vlookup formula typing in the lookup
gt; gt; gt;gt; values
gt; gt; gt;gt; and those that I tried I got a correct hit, no errors at all so I can
gt; gt; gt;gt; only
gt; gt; gt;gt; assume that what you think is a match is not,
gt; gt; gt;gt; you can test with a cell that you know should be correct and then compare
gt; gt; gt;gt; them =cell=cell2 or even check how many characters
gt; gt; gt;gt;
gt; gt; gt;gt; =LEN(lookup_Value_cell)
gt; gt; gt;gt; =LEN(value_from Table_cell)
gt; gt; gt;gt;
gt; gt; gt;gt; same number?
gt; gt; gt;gt;
gt; gt; gt;gt; --
gt; gt; gt;gt; Regards,
gt; gt; gt;gt;
gt; gt; gt;gt; Peo Sjoblom
gt; gt; gt;gt;
gt; gt; gt;gt; (No private emails please)
gt; gt;
gt; gt;