I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

Post your VLOOKUP formula, perhaps there's a clue therein...........

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

Here is my formula:

=VLOOKUP(B3,'DRG ref'!$A$2:$B$580,2,FALSE)

Thanks!

"CLR" wrote:

Post your VLOOKUP formula, perhaps there's a clue therein...........

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

I dunno, it might still be a formatting issue.........your formula works fine
in my test......you do understand that it is looking for an exact match with
the FALSE option.......perhaps a type-O, or unseen leading/trailing
spaces,............

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Here is my formula:

=VLOOKUP(B3,'DRG ref'!$A$2:$B$580,2,FALSE)

Thanks!

"CLR" wrote:

Post your VLOOKUP formula, perhaps there's a clue therein...........

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

YOU ARE BRILLIANT! I didn't think about unseen leading/trailing spaces! So
I used the Trim() function on my source table and it now works! Thanks so
much!!

"CLR" wrote:

I dunno, it might still be a formatting issue.........your formula works fine
in my test......you do understand that it is looking for an exact match with
the FALSE option.......perhaps a type-O, or unseen leading/trailing
spaces,............

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Here is my formula:

=VLOOKUP(B3,'DRG ref'!$A$2:$B$580,2,FALSE)

Thanks!

"CLR" wrote:

Post your VLOOKUP formula, perhaps there's a clue therein...........

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!

You're welcome........thanks for the feedback, and the kind words.

Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

YOU ARE BRILLIANT! I didn't think about unseen leading/trailing spaces! So
I used the Trim() function on my source table and it now works! Thanks so
much!!

"CLR" wrote:

I dunno, it might still be a formatting issue.........your formula works fine
in my test......you do understand that it is looking for an exact match with
the FALSE option.......perhaps a type-O, or unseen leading/trailing
spaces,............

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Here is my formula:

=VLOOKUP(B3,'DRG ref'!$A$2:$B$580,2,FALSE)

Thanks!

"CLR" wrote:

Post your VLOOKUP formula, perhaps there's a clue therein...........

Vaya con Dios,
Chuck, CABGx3



"yvette" wrote:

Thanks for the suggestion. Unfortunately, it still doesn't work. :(

I think the problem lies in the source table (spreadsheet A) -- is there
some reason why the cells aren't being read/recognized until I double-click
them?


"CLR" wrote:

Quite possibly the problem is one of formatting.....for VLOOKP to work, both
the value to be looked up and the values in the lookup table must be of the
same format.......ie: both numbers or both TEXT.......sometimes even tho they
LOOK like numbers, they may be formatted as TEXT.

hth
Vaya con Dios,
Chuck, CABGx3




"yvette" wrote:

I'm doing a VLOOKUP but getting the #N/A error even though I know the values
I'm looking up in another spreadsheet (spreadsheet A) are there. When I go
to spreadsheet A and double-click the cells with the values I want to show
up, the #N/A goes away and the value appears (so I know it's not a problem
with my VLOOKUP statement). Is there any way to "activate" all the values in
spreadsheet A so I don't have to double-click all the cells? Is there
another problem present that I'm overlooking?

Thanks!