Excel VLookup giving #N/A

[Qik3Coder]

Alirhgt, i swear i am following the formula.

Data set:
A;B;C;D
7023881853;10;7023881853;10
7023881875;20;7023881875;20
7023882023;30;7023882023;30


in column G i have:
=VLOOKUP(A1, C1:C3,1,FALSE)

I get an #N/A. Looking for help,
Thanks,

-The answer to your problem may not be the answer to your question.

 

[Qik3Coder]

Nevermind...

One column was an int, and the other was a text, so it was failing the VLookup.

Thanks,

-The answer to your problem may not be the answer to your question.

 

[SkipVought]

NUMBERS and TEXT don't work together well, do they?

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[Qik3Coder]

rawww, they hate me sometimes...
I had to do =Sheet2!A1, so i wasnt seeing the lil green arrow that indicates number stored as text.

-The answer to your problem may not be the answer to your question.

 

[xlStar]

Use can use either...

=VLOOKUP(TEXT(A1,0), C1:C3,1,FALSE)

=VLOOKUP(VALUE(A1), C1:C3,1,FALSE)

Use the =IsText(A1) formula to determine what the
format a certain cell is.

The IF formula is good...

=IF(IsText(A1))=true,VLOOKUP(TEXT(A1,0), C1:C3,1,FALSE),VLOOKUP(VALUE(A1), C1:C3,1,FALSE))

 

[yogia]

Hi Qik3Coder:

Let us have a look at the following illustration where the entries in column A as well as in C are numbers enterd as mixed TEXT and NUMERIC ...

Would this do?

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[Qik3Coder]

Thanks for the help, but i got the point. I normally don't use excel at this level. I use it for storing and transfering my data. having to manipulate values in it was something new for me.

Thanks for all the help.

-The answer to your problem may not be the answer to your question.