but whatever i understand vlookup only search for a particular value which is
listed in the table. Then how it can find a inbetween value.
Like for example if i have a table say col A={8,10,12,14...............),
Now for calculated value 9, how vlookup will find, 9 is not available in the
table. And what will be col B.
But answer will be for calculated value of say 8.5,8.8 or may be 9,10 it
will be 10, when it exceeded 10, it will have the next higher value
available, i.e. 12.
Hope I explain correctly.



Sheelo has everything right except when it is equal to the value provided.

"francis" wrote:

Create a table with the columns on these value and
place a Lookup formula...Vlookup or Index Match will be
able to solve this easily.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"raj74" wrote:

Thanks, but probably I wrote little bit wrong in expressing the algorithm.
Corrected will be
THKcal (lesss or equal) =< 8, Thk Provided, THKprov = 8
8< THKcal =<10 THKprov
= 10

And So on.

In your case if thk calculated is 8mm, thickness is coming 10mm which should
be 8 mm.

Regards




"Sheeloo" wrote:

Use
=LOOKUP(A1,{0,8,10,12,14,16,18,20,25,28,30,32},{8, 10,12,14,16,18,20,25,28,30,32,"Error"})

where A1 contains the THKcal value... It will give show ERROR if A1 has the
value 32 or above

"raj74" wrote:

I have to express the following logic.

Available Plate Thickness 8, 10, 12, 14, 16, 18, 20, 25, 28, 30, 32

The logic is if my calculated thickness is, THKcal < 8, Thk Provided,
THKprov = 8

8< THKcal <10
THKprov = 10

10< THKcal <12
THKprov = 12


.......................... ................


........................ ....................

28< THKcal <30
THKprov = 30

30< THKcal
THKprov = 32

Now this logic I have tried as
=if(THKcal<8,8,if(and(8<THKcal,THKcal<10),10,if(an d(10<THKcal,THKcal<12),12,........................ if(and(28<THKcal,THKcal<30),30,32))...)
But problem is I can no go beyond certain amount of limit for the nested loop.
What is the solution. Any easier way to express it. Anyway thanks.

Regards