Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() rebecca, In Natl Info B61 =IF('Natl Rank'!C1="Month of March 06",'1'!C9,"") Assuming that your sheet tab 1 is named "1". This returns a blank if the condition is not true. It looks like you had the value if true and value if false reversed. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=530567 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help, I've been struggling for weeks! | Excel Worksheet Functions | |||
Struggling for a solution | Excel Worksheet Functions | |||
Struggling Again With A VLOOKUP | Excel Worksheet Functions | |||
Help, I'm Struggling! | New Users to Excel | |||
Need Function for adding rows on multiple sheets... struggling rookie ;) Thanks. | Excel Worksheet Functions |