Share via

Help with a formula

Anonymous
2024-08-17T17:08:21+00:00

I have three columns A,B & C. There will be instances of where postcodes will be in A,B or C. i would like to write a formula that says if there is data in C use it, but if C is blank use the data in B and then finally if C and B are blank then use the data in column A

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-19T09:05:00+00:00

    Perfect, thank you again.

    Was this answer helpful?

    0 comments
  2. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-08-19T08:49:58+00:00

    Hi,

    In cell D2, enter this formula and drag down

    =lookup(2,1/(A2:C2<>""),A2:C2)

    Hope this helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2024-08-19T08:08:46+00:00

    Hi, thank you for your response i am not sure i explained the problem clearly enough.

    The formula i was trying to write in column D would essentially have collected the data in the first column that wasn't blank (going right to left ie C, B, A.)

    The intended results from the formula would been as follows D2 - TB53 7AB in D3 - A1 5PA and in D4 - AB3 5ST ie ignoring the blank cells.

    Thank you

    Was this answer helpful?

    0 comments
  4. Ashish Mathur 102K Reputation points Volunteer Moderator
    2024-08-18T01:02:32+00:00

    Hi,

    Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.

    Was this answer helpful?

    0 comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2024-08-17T18:21:36+00:00

    E3: =FILTER(A1:C11,(C1:C11=E1)+(B1:B11=E1)+(A1:A11=E1),"none")

    Was this answer helpful?

    0 comments