I want column U to equal the value of column P. However, if column P says #N/A N/A then I want it to populate from column L instead. Is there a formula that will do this for me? Sorry if I've not explained it very well, I'm extremely new to excel!
Is there also a way of showing which column it has used?
U
orP
? Or the entire column? Have you done any research or tried anything yet? If you have, it would be helpful if you edit your question to include the formula you are trying.=IF(ISBLANK(A1),B1,A1)
should address the question in the title, for the benefit of others reaching this page.