Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change value based on another cell's value | Excel Discussion (Misc queries) | |||
How to change an other cell's value? | Excel Discussion (Misc queries) | |||
Change a cell's value using a button | Excel Discussion (Misc queries) | |||
How can I change a text to a cell's address? | Excel Discussion (Misc queries) | |||
How to change a single cell's width | Excel Worksheet Functions |