how to use "INT" function....????

[amkumar]

Hello,

sometime i use vlookup formula in excel but not getting correct result, because the lookup value is not in correct format.
so how can i use "INT" function with vlookup.

lookup value is numbers like- 16,18,20

 

[kvsrinivasamurthy]

post deleted.

 

[amkumar]

????

 

[Aladin Akyurek]

Hello,

sometime i use vlookup formula in excel but not getting correct result, because the lookup value is not in correct format.
so how can i use "INT" function with vlookup.

lookup value is numbers like- 16,18,20

What does 16,18,20 mean if not 16 then 28 then 20?

16 is aready an integer, that is, INT(16) = 16.

 

[amkumar]

16,18,20 is lookup value
like in below table....

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]lookup value [/TD]
[TD]result[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i want to use "INT" formula with vlookup function.

 

[Aladin Akyurek]

16,18,20 is lookup value
like in below table....

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]lookup value[/TD]
[TD]result[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

i want to use "INT" formula with vlookup function.

You don't apply INT to a number which is already an INTeger. But what is your VLOOKUP formula?

 

[amkumar]

i under that i don't apply INT to a number which is already an integer, but suppose if 16 is not in number format then i can use INT function to convert it into number format.
my main query is can i use INT & VLOOKUP (both) functions in a single cell, when my lookup value is not in number format.

 

[Aladin Akyurek]

i under that i don't apply INT to a number which is already an integer, but suppose if 16 is not in number format then i can use INT function to convert it into number format.
my main query is can i use INT & VLOOKUP (both) functions in a single cell, when my lookup value is not in number format.

INT doesn't convert from text number to integer. Why don't you poste your VLOOKUP formula without INT?