Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue between cells
I have a issue with using a formula to look at another cell with a formula in
it and pulling the data correctly. Column "L" has a formula (vlookup) pulling a cell over if it has a particular symbol "HV". Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the those numbers in "M" or leaves blank if it equals anything else. Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in "M". My problem is Column "N" it seems, can't differentiate what is in column "M". It seems it does not like the formula in "M". Formulas being used: Column €śL€ť: =IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLOO KUP($L$1,A2:H2,8,FALSE)) Column €śM€ť: =IF(L2=2,"2",IF(L2=8,"8","")) Column €śN€ť: =IF(M2=2,J2,IF(M2=8,J2,"")) -- Baltimore Ravens |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue between cells
You should remove the quotes from around the numbers 2 and 8 in your
formula in M: =IF(L2=2,2,IF(L2=8,8,"")) A slightly more efficient version would be: =IF(OR(L2=2,L2=8),L2,"") Hope this helps. Pete On Jan 30, 2:41 pm, Ravens Fan wrote: I have a issue with using a formula to look at another cell with a formula in it and pulling the data correctly. Column "L" has a formula (vlookup) pulling a cell over if it has a particular symbol "HV". Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the those numbers in "M" or leaves blank if it equals anything else. Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in "M". My problem is Column "N" it seems, can't differentiate what is in column "M". It seems it does not like the formula in "M". Formulas being used: Column "L": =IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLOO KUP($L$1,A2:H2,8,FALSE)) Column "M": =IF(L2=2,"2",IF(L2=8,"8","")) Column "N": =IF(M2=2,J2,IF(M2=8,J2,"")) -- Baltimore Ravens |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue between cells
The formula in column M is putting a text value ("2" or "8") into the cell
and your formula in column N is looking for an integer, not a string. Modify the formula in column N to this: =IF(M2="2",J2,IF(M2="8",J2,"")) -- Kevin Backmann "Ravens Fan" wrote: I have a issue with using a formula to look at another cell with a formula in it and pulling the data correctly. Column "L" has a formula (vlookup) pulling a cell over if it has a particular symbol "HV". Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the those numbers in "M" or leaves blank if it equals anything else. Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in "M". My problem is Column "N" it seems, can't differentiate what is in column "M". It seems it does not like the formula in "M". Formulas being used: Column €śL€ť: =IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLOO KUP($L$1,A2:H2,8,FALSE)) Column €śM€ť: =IF(L2=2,"2",IF(L2=8,"8","")) Column €śN€ť: =IF(M2=2,J2,IF(M2=8,J2,"")) -- Baltimore Ravens |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue between cells
Thanks, worked great. I'm a novice at excel and am learning as I go.
Thanks again for both respones. -- Baltimore Ravens "Pete_UK" wrote: You should remove the quotes from around the numbers 2 and 8 in your formula in M: =IF(L2=2,2,IF(L2=8,8,"")) A slightly more efficient version would be: =IF(OR(L2=2,L2=8),L2,"") Hope this helps. Pete On Jan 30, 2:41 pm, Ravens Fan wrote: I have a issue with using a formula to look at another cell with a formula in it and pulling the data correctly. Column "L" has a formula (vlookup) pulling a cell over if it has a particular symbol "HV". Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the those numbers in "M" or leaves blank if it equals anything else. Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in "M". My problem is Column "N" it seems, can't differentiate what is in column "M". It seems it does not like the formula in "M". Formulas being used: Column "L": =IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLOO KUP($L$1,A2:H2,8,FALSE)) Column "M": =IF(L2=2,"2",IF(L2=8,"8","")) Column "N": =IF(M2=2,J2,IF(M2=8,J2,"")) -- Baltimore Ravens |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula issue between cells
You're welcome.
Presumably, Ravens is some sports club in Baltimore ? Along the lines of Manchester United ? Pete On Jan 30, 3:38*pm, Ravens Fan wrote: Thanks, worked great. I'm a novice at excel and am learning as I go. Thanks again for both respones. -- Baltimore Ravens "Pete_UK" wrote: You should remove the quotes from around the numbers 2 and 8 in your formula in M: =IF(L2=2,2,IF(L2=8,8,"")) A slightly more efficient version would be: =IF(OR(L2=2,L2=8),L2,"") Hope this helps. Pete On Jan 30, 2:41 pm, Ravens Fan wrote: I have a issue with using a formula to look at another cell with a formula in it and pulling the data correctly. Column "L" has a formula (vlookup) pulling a cell over if it has a particular symbol "HV". Column "M" looks at "L" and if it equals 2 or 8 than it puts either of the those numbers in "M" or leaves blank if it equals anything else. Column "N" looks at "M" and pulls the data from column "J" if a 2 or 8 is in "M". My problem is Column "N" it seems, can't differentiate what is in column "M". It seems it does not like the formula in "M". Formulas being used: Column "L": * * * *=IF(ISNA(VLOOKUP($L$1,A2:H2,8,FALSE))=TRUE,"",VLO OKUP($L$1,A2:H2,8,FALSE)) Column "M": =IF(L2=2,"2",IF(L2=8,"8","")) Column "N": =IF(M2=2,J2,IF(M2=8,J2,"")) -- Baltimore Ravens- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB macros issue with selecting cells on different page | Excel Discussion (Misc queries) | |||
Another Visual Basic/Dependant Cells issue | Excel Worksheet Functions | |||
formula issue | Excel Discussion (Misc queries) | |||
Format cells (number) issue | Excel Discussion (Misc queries) | |||
An issue regarding the formula | Excel Discussion (Misc queries) |