Edited as response to comment: I had to copy data into a new sheet, which is why it doesnt entirely match your answer.

Here is where Im at now: attached screendump is new. This is from the shared spreadsheet

Hope you can help with this one, usually get on OK with a function or two, but this wont work for me :-)

I need a code in N24 that currently says #ERROR! to do the following: If G24 = AAA AND H24:L24 contains the text DEL 1, it should show E24 (3).

The result should be, under LIST, there should be a 3, because DEL 1 is selected in one of the cells. It should check the entire H-L columns, but only list the cell-info from the TEXT-column, if that same line also has AAA in STATUS.

Hope it makes sense.




| improve this answer | |
  • Much appreciated - but it just gives a "parse error"? – Lasse Hanberg Nov 11 '19 at 7:46
  • Please share a copy of your spreadsheet. – Tedinoz Nov 11 '19 at 8:05
  • What sheet/cell has the parse error? – Tedinoz Nov 11 '19 at 10:05
  • Works just fine. Of course, you need to replace "AAA" with OPTION1", and "DEL1" with "DEL 1" – Tedinoz Nov 11 '19 at 10:15
  • Hmm, just pressed the link, and seems my saves/changes doesnt show on shared file... weird – Lasse Hanberg Nov 11 '19 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.