Forum Discussion
Complex look up with output
Hi, I'm looking for help with a complex lookup problem. I have tried a number of options but haven't been able to achieve the desired result. If it were possible to use Conditional Formatting to hi...
Many thanks for your response! Great use of Chat GPT :) I'm not sure if it will do exactly what I need, but there's a couple of things here I can try. Given this was a very simplified version of a more complex solution I am trying to solve, I think I'll put Chat GPT to the challenge with the actual data and see what it comes back with. So thanks for the 'prompt' on using AI... 😁
ChatGPT had no idea how to do it. It just cleaned up the introduction a bit. ChatGPT is actually pretty bad at Excel (at least it is bad at functional programming in Excel).
Tell me exactly what it is you need it to do and I can probably expand the formula as necessary.
