| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If question
Cell S12 - =IF((A12)*(A12<""),VLOOKUP(A12,'Books Borrowed'!$A$5:$G$35,3),"")
Cell A12 contains a value & In cell S12 i get the answer #N/A (I was expecting this answer, there is nothing wrong) However, since Cell A12 is not in the table array (From above formula) 'Books Borrowed'!$A$5:$G$35 (This is where i got the #N/A from) i do not want that text to actually appear(Want the cell to be blank). if that makes sense How can i modify my formula to allow this to happen I am not enitrely sure, but i think the vlookup section of the formula may need the modifying |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| One question | Excel Discussion (Misc queries) | |||
| If-then-next question | Excel Discussion (Misc queries) | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Threaded Mode
