Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone write a simple if statement for me?
If D2 is null then P2 is null else P2 = VLOOKUP(D2,Comments!$A$2:$B$9999,2,FALSE) I'm looking for something I can simply paste into formula builder. I am refreshing data from a query, and don't know how many lines I'll import. If the row is blank as I have it now - the cell has a #N/A in it - so it causes printing problems. Or is there a better way to accomplish this? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple IF statement | Excel Discussion (Misc queries) | |||
Simple IF statement | Excel Worksheet Functions | |||
Simple If Statement | Excel Worksheet Functions | |||
Simple IF statement | Excel Programming | |||
Simple If Statement | Excel Programming |