Multiple conditions

  • Thread starter Thread starter arv1980
  • Start date Start date
A

arv1980

Hi,

I am trying to put multiple conditions in if like

A1 B1
Loan Sanctioned by
1000
12000
150000
30000

now what i want is if the loan is between 1000 & 10000 it is sanctione
by x, 10000-20000 it is sanctioned by y, 30 - 40000 by z and so on an
so forth. I want that as soon as i put value in a1 immediatel
corresponding value should come in B1. Is this possible. I trie
multiple if command, but its giving some error. is it possible withou
if command. and if i use if command and copy data from one workbook t
another, it will be dependent on original workbook if i delete origina
it might give me error. Please help.

Thanking you and waiting for some kind reply.


ar
 
Hi Arv1980!

In J1:K10 I have:

0 Fred
10000 John
20000 Bill
30000 Mary
40000 Harry
50000 Ann
60000 Joan
70000 Norman
80000 Robert
90000 Big Boss

Then in B2 I use the formula:

=VLOOKUP(A2,$J$1:$K$10,2)
 
Hi

you can only nest 7 levels in an IF function so to get around this
limitation you can use the VLOOKUP function
create a table somewhere in your workbook (say sheet 2- range a1:b6) that
lists all of the ranges and the sactioned by person
e.g.
A B
1 0 a
2 1000 x
3 10000 y
4 20000 z
5 30000 aa
6 40000 bb

etc

then select from A1 to the end of the values in column B (e.g. A1:B6)
click in the name box (little box to left of formula bar) and type a name
(e.g. SactionedTable) and press enter (range names can not have spaces)

now return to your original set of figures
click in B2 and type
=VLOOKUP(A2,SactionedTable,2)
this will lookup the table that you created and return the name of the
person in column B
you can fill this formula down for each of the values in column A

Hope this helps - let us know how you go
Cheers
JulieD
 
Back
Top