 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006VLOOKUP with IF function
I have used the VLookup function on an invoice that will print the price and description of an item when the item number is typed in. I want to removed the #N/A from the invoice when the lines are blank. I was told to use the IF function. My lookup function is =VLOOKUP(A24,Product!A8:D14,2) If I add the IF function to it-- would it look like =IF(A24="","")=VLOOKUP(A24,Product!A8:D14,2) ? Or just where would the IF formula go and did I type it correctly to say if the cell is empty? Thanks Bev Bev =IF(A24="","",VLOOKUP(A24,Product!A8:D14,2)) Regards Trevor >I have used the VLookup function on an invoice that will print the price >and [quoted text clipped - 15 lines] > Thanks > Bev =IF(ISERR(putyourvlookuphere)=TRUE,"",putyourvlookuphere) It could look something like I have above. It will check to see if the result is an error #N/A included I believe, if it is it will put in a blank, if not it will put the actual result of the vlookup. > I have used the VLookup function on an invoice that will print the price and > description of an item when the item number is typed in. I want to removed [quoted text clipped - 12 lines] > Thanks > Bev ISERR excludes #N/A. ISERROR handles all of the error types. > =IF(ISERR(putyourvlookuphere)=TRUE,"",putyourvlookuphere) Since the ISERR(OR) function returns a boolean, either TRUE or FALSE, there's no need for an equality comparison: ISERR(putyourvlookuphere)=TRUE ISERR(putyourvlookuphere) will do. Biff > =IF(ISERR(putyourvlookuphere)=TRUE,"",putyourvlookuphere) > [quoted text clipped - 23 lines] >> Thanks >> Bev just thinking...does each of your invoice spreadsheet needs to be saved each time you create one with a served invoice number ? If you do, better clean the non-servable formula....Just try to maintain a template filled with the formula for your next invoicing.... > I have used the VLookup function on an invoice that will print the price and > description of an item when the item number is typed in. I want to removed [quoted text clipped - 12 lines] > Thanks > Bev |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.