Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple formula NOT working :(
Hi all,
I have a formula I am trying to put together and it just isn't working, despite it's simplicity - and wondered if anyone could point out where I'm going wrong... In cell C20 are the letters MP. In cell AG20 (the 21st column in the vlookup below), is the figure 3. In cell AT20, is the figure 37. In cell Summary!$Z$7 is the number 17. In cell D10 is the following formula: =IF(OR(AT20=0,VLOOKUP($C20,$C$4:$AP$108,Summary!$Z $7+4,FALSE)=0),"",IF(VLOOKUP($C20,$C$4:$AP$108,Sum mary!$Z$7+4,FALSE)AT20,"ALARM","")) The lookup identifies the MP, finds the 21st column in the lookup, which seems to be the figure 3, and compares it to AT20, which is 37. If AT20 is smaller than the 21st column figure (3 in this case), "ALARM" is displayed. However 37 is clearly not smaller than 3. And the formatting is correct. Anyone see why the formula results in "ALARM"??? Thanks in anticipation Danny |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple formula NOT working :(
Danny, In your range for the Vlookup, column W is the 21st Column. Column AG is the 31st Column If you have hidden columns, they will still be counted by the vlookup Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple formula NOT working :(
Yes, thank you - my predecessor had hidden those columns without me noticing
- silly me huh Thanks for pointing that out... "SIR Knight" wrote: Danny, In your range for the Vlookup, column W is the 21st Column. Column AG is the 31st Column If you have hidden columns, they will still be counted by the vlookup Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple formula NOT working :(
It works fine for me. I would point out that column 21 for me in that
formula is W, not AG. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Danny Lewis" wrote in message ... Hi all, I have a formula I am trying to put together and it just isn't working, despite it's simplicity - and wondered if anyone could point out where I'm going wrong... In cell C20 are the letters MP. In cell AG20 (the 21st column in the vlookup below), is the figure 3. In cell AT20, is the figure 37. In cell Summary!$Z$7 is the number 17. In cell D10 is the following formula: =IF(OR(AT20=0,VLOOKUP($C20,$C$4:$AP$108,Summary!$Z $7+4,FALSE)=0),"",IF(VLOOK UP($C20,$C$4:$AP$108,Summary!$Z$7+4,FALSE)AT20,"A LARM","")) The lookup identifies the MP, finds the 21st column in the lookup, which seems to be the figure 3, and compares it to AT20, which is 37. If AT20 is smaller than the 21st column figure (3 in this case), "ALARM" is displayed. However 37 is clearly not smaller than 3. And the formatting is correct. Anyone see why the formula results in "ALARM"??? Thanks in anticipation Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Extended Formula not working | Excel Discussion (Misc queries) | |||
Simple Excel Formula Help | New Users to Excel | |||
Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
simple formula | Excel Worksheet Functions | |||
Excel2000 A working formula has {braces} which disappear. Why? | Excel Worksheet Functions |