Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 09-05-2016, 07:37 PM
innkeeper9 innkeeper9 is offline If=Then from one column cells to next column equivalent cells Windows 7 32bit If=Then from one column cells to next column equivalent cells Office 2007
Novice
If=Then from one column cells to next column equivalent cells
 
Join Date: Aug 2016
Posts: 20
innkeeper9 is on a distinguished road
Default

Thank you for your help! I sort of got it to work, but I can't find out how to have it not put a #NA in a cell that is empty. The only way I could figure out how to do it, was to remove the vlookup from any empty cell, but that means having to put it back if I end up with a name in the cell. Isn't there a way to include cells that if they are blank nothing gets put in the corresponding one?

Ruth
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
If=Then from one column cells to next column equivalent cells How to obtain a column total using only specific cells Jo Freeman Excel 3 03-20-2015 06:18 AM
Return Sum value of one column from cells not blank in another column zulugandalf Excel 3 08-14-2014 03:37 AM
Summing Non Contiguous Cells in a Row or Column Joe Ottenhof Excel 4 12-19-2012 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft