Function to Reference Multiple Cells for Values

Copper Contributor

Hi there! So I want to use Excel to have a cell reference 4 other cells. The 4 other cells will either contain a number (1, 2, 3, or 4) or N/A (these 4 cells are also using IF functions so if their conditions aren't met, N/A is the entry).


Which formula can I use for my cell with "VALUE!" to only paste the data from the cells below it that actually has a numerical value, not N/A? Hope that made sense. Thanks!



1 Reply



If you have access to TEXTJOIN and FILTER you can try this formula. The formula is in cell E1 and copied to cell F1.