![]() |
#3
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |