Name Findout From a interval range

[mun04]

Hiiii
I am facing a silly problem i think u guys are rescue me from that...
My prob like I have two cloum one colum contain Name of person and
another coloum contain their salary.I prepared a interval table contain
4 row according to salary range....I have find the name whos salary has
on the specified range on ist row of interval table....

Can any one giv the idea about that..Perhaps I tried it VLook up
Function...But i faced proble to sort the name from ist colum

 

[random1970]

Here's a simple way around it.

Insert a column before your name and salary columns. This will mean
your names are now in column B and salaries in column C.

In cell A1, type =C1. Fill this down. This copies the salaries into
column A. Use your VLOOKUP function to find a value in column A and
return the name in column B. e.g. If the required salary is in F1,
type =VLOOKUP(F1,$A$1:$B$4,2,true) into F1. The name you want should
appear in F2.

If you don't want the extra column to show, format the font in column A
as white, or just hide the column.

 

[Ardus Petus]

Without any extra column:

=INDEX($A$1:$A$4,MATCH(F1;$B1:$B4;0))

HTH
--
AP

"random1970" <[email protected]> a
écrit dans le message de
news:[email protected]...