Hello! I'm trying to create a formula which checks to see if the value in multiple cells = N/A, to return blanks otherwise return another value. I'm looking at the data by row. For example using the data below. The formula in G2 would be IF B2 = #N/A then Blank, otherwise = B1; IF C2 = #N/A then Blank, otherwise = C1; IF D2 = #N/A then Blank, otherwise = D1; and IF E2 = #N/A then Blank, otherwise = E1. There should only be one value for each row, but need a quick way to evaluate, since the value is not in the same column each time.