CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE
 

Here is my issue;

when I write this IF(F11=6,VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE) it works
just fine, but I want to be able to change F11 from 6 to 2 in the cell, and
the rest should be the same result.
So what I want is to be able to write: if F11=6 or F11=2 and get the same in
return.
I just want to be able to change the 6 to 2 to cell F11 and be able to get
the same answer in return.
'2 5 6' is the sheet where I have the range of data to VLOOK to in 2 columns.

I know that exel can afford only 6 nested if, but I filled them all up so I
need some more...
SOME HELP PLEASE

CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PLEASE
 

You haven't defined what to do if F11 does not equal 6 or 2.

Try this:

=IF(OR(F11={6,2}),VLOOKUP(G15,'2 5 6 '!A7:B181,2,0),"")

That'll leave the cell blank if F11 does not equal 6 or 2.

--
Biff
Microsoft Excel MVP


"Vangelo" wrote in message
...
Here is my issue;

when I write this IF(F11=6,VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE) it works
just fine, but I want to be able to change F11 from 6 to 2 in the cell,
and
the rest should be the same result.
So what I want is to be able to write: if F11=6 or F11=2 and get the same
in
return.
I just want to be able to change the 6 to 2 to cell F11 and be able to get
the same answer in return.
'2 5 6' is the sheet where I have the range of data to VLOOK to in 2
columns.

I know that exel can afford only 6 nested if, but I filled them all up so
I
need some more...
SOME HELP PLEASE

CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PL
 

IF(OR(F11=6,F11=2);VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE)


"T. Valko" skrev:

You haven't defined what to do if F11 does not equal 6 or 2.

Try this:

=IF(OR(F11={6,2}),VLOOKUP(G15,'2 5 6 '!A7:B181,2,0),"")

That'll leave the cell blank if F11 does not equal 6 or 2.

--
Biff
Microsoft Excel MVP


"Vangelo" wrote in message
...
Here is my issue;

when I write this IF(F11=6,VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE) it works
just fine, but I want to be able to change F11 from 6 to 2 in the cell,
and
the rest should be the same result.
So what I want is to be able to write: if F11=6 or F11=2 and get the same
in
return.
I just want to be able to change the 6 to 2 to cell F11 and be able to get
the same answer in return.
'2 5 6' is the sheet where I have the range of data to VLOOK to in 2
columns.

I know that exel can afford only 6 nested if, but I filled them all up so
I
need some more...
SOME HELP PLEASE

CHANGE ONE CELL'S VALUE AND GET THE SAME RETURN - SOME HELP PL
 

HEY, EXCELENT ...YOU ARE EXCELENT....THANKS SO MUCH ...IT WORKED GREAT...

Now I have three more to add but I already reached to 6IF's so if you can
help...Thanks again

"excelent" wrote:

IF(OR(F11=6,F11=2);VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE)


"T. Valko" skrev:

You haven't defined what to do if F11 does not equal 6 or 2.

Try this:

=IF(OR(F11={6,2}),VLOOKUP(G15,'2 5 6 '!A7:B181,2,0),"")

That'll leave the cell blank if F11 does not equal 6 or 2.

--
Biff
Microsoft Excel MVP


"Vangelo" wrote in message
...
Here is my issue;

when I write this IF(F11=6,VLOOKUP(G15,'2 5 6 '!A7:B181,2,FALSE) it works
just fine, but I want to be able to change F11 from 6 to 2 in the cell,
and
the rest should be the same result.
So what I want is to be able to write: if F11=6 or F11=2 and get the same
in
return.
I just want to be able to change the 6 to 2 to cell F11 and be able to get
the same answer in return.
'2 5 6' is the sheet where I have the range of data to VLOOK to in 2
columns.

I know that exel can afford only 6 nested if, but I filled them all up so
I
need some more...
SOME HELP PLEASE