I have 12 cells, A1:C4, up to any 6 of which may randomly contain values depending upon data entry. Using formulas only, I would like to find any of the 6 values entered in A1:C4 and display them in A6:A11, searching in order of A1, B1, C1... (across rows beginning with row 1)
I've been trying to enter formulas (index, choose, lookups,...) in A6:A11 to do the search and return, but it seems to get to complicated for me. I know it must be easier than I am making it.
Any help? Thanks much.
I've been trying to enter formulas (index, choose, lookups,...) in A6:A11 to do the search and return, but it seems to get to complicated for me. I know it must be easier than I am making it.
Any help? Thanks much.