[Chip]

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

[JE McGimpsey]

What does "my formula doesn't work" really mean?

The formula is syntactically correct.



In article ,
Chip wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

[Ron Rosenfeld]

On Sat, 7 Jun 2008 09:32:02 -0700, Chip wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

Based on the data you have provided, I would guess the problem to be that your
lookup value is not what you think it is or your table array does not contain
what you think it does or is located in a different area than what you have
referenced.

--ron

[Mike H]

Hi,

There's nothing wrong with the formula so if your getting unexpected results
then it looks like a data problem.

You don't say what 'doesn't work' means. What result do you get?

Mike

"Chip" wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

[Chip]

On both Sheet1 and Sheet2 I have recurring numbers (such as A135 and a second
line of A135). Could that mess up the search ? Probably so because it
wouldn't know which one to pick.

If that is true, is there a formula to get rid of all repeats of the same
number ?

"Ron Rosenfeld" wrote:

On Sat, 7 Jun 2008 09:32:02 -0700, Chip wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

Based on the data you have provided, I would guess the problem to be that your
lookup value is not what you think it is or your table array does not contain
what you think it does or is located in a different area than what you have
referenced.

--ron

[Mike H]

No that wouldn't cause a problem it would simply find the first match.

You are looking up A1 so try this.
manually find a match for A1 on sheet 2 and note the cell address.

In a cell on a1 enter the formula

=A1=Sheet2!A3
change A3 the address you manually found the match in and
If it doesn't return TRUE then you have a data issue.

Mike

"Chip" wrote:

On both Sheet1 and Sheet2 I have recurring numbers (such as A135 and a second
line of A135). Could that mess up the search ? Probably so because it
wouldn't know which one to pick.

If that is true, is there a formula to get rid of all repeats of the same
number ?

"Ron Rosenfeld" wrote:

On Sat, 7 Jun 2008 09:32:02 -0700, Chip wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

Based on the data you have provided, I would guess the problem to be that your
lookup value is not what you think it is or your table array does not contain
what you think it does or is located in a different area than what you have
referenced.

--ron

[Mike H]

I meant of course

In a cell on Sheet 1 enter the formula

not

In a cell on a1 enter the formula


Mike


"Mike H" wrote:

No that wouldn't cause a problem it would simply find the first match.

You are looking up A1 so try this.
manually find a match for A1 on sheet 2 and note the cell address.

In a cell on a1 enter the formula

=A1=Sheet2!A3
change A3 the address you manually found the match in and
If it doesn't return TRUE then you have a data issue.

Mike

"Chip" wrote:

On both Sheet1 and Sheet2 I have recurring numbers (such as A135 and a second
line of A135). Could that mess up the search ? Probably so because it
wouldn't know which one to pick.

If that is true, is there a formula to get rid of all repeats of the same
number ?

"Ron Rosenfeld" wrote:

On Sat, 7 Jun 2008 09:32:02 -0700, Chip wrote:

I am trying to use VLOOKUP and my formula doesn't work....I've used this
function several times before.....am I missing something ?

=VLOOKUP(A1,Sheet2!A$1:B$10788,2,FALSE)

A1 is beginning of spreadsheet and info I need is in column 2 of Sheet2.

Based on the data you have provided, I would guess the problem to be that your
lookup value is not what you think it is or your table array does not contain
what you think it does or is located in a different area than what you have
referenced.

--ron

[Ron Rosenfeld]

On Sat, 7 Jun 2008 10:11:00 -0700, Chip wrote:

On both Sheet1 and Sheet2 I have recurring numbers (such as A135 and a second
line of A135). Could that mess up the search ? Probably so because it
wouldn't know which one to pick.

It depends on what you want for a result. When there are multiple identical
matches, your formula will return the first match.

What do you mean by "mess up the search"?

What kind of a number is A135? It doesn't seem to be a real number, nor a
complex number. Is it a numeric value that you have custom formatted to
display this way?

What do you mean, in your previous post, by "doesn't work"?



If that is true, is there a formula to get rid of all repeats of the same
number ?

There are methods to get rid of duplicates. You can filter your list and
select to return only unique entries. I don't have the slightest idea whether
that will be of any value to you.

The reason you have been getting responses that are less than helpful is
because we are limited by the amount of information you have provided.

In order to receive pertinent advice, instead of generalities, it would be best
if you would provide examples of your data, lookup values, etc. You need to
provide the actual data that is in the formula bar when you select the cell,
and not what the cell appears to show -- as that can be influenced by
formatting. The contents of the cells can also be affected by whether the
values are entered directly, or generated by a formula. If the latter, the
precedents should also be supplied.
--ron