I am after a bit of help to write a formula as the new update for numbers has my existing formula now coming up with errors.
I was using the look up function to find e.g.: look up ( apple a1, in table 1 a1:a30, to return a $ f1:30) this was bringing back a correct $ and if there was no $ it would come up with ! Or if apple wasn’t in the list it would come up with !. This was fine!
IT isn’t doing that now if apple isnt in the list it is returning $2 or returning a non existent value.
I Have tried vlookup it returns apple instead of $, I have tried combinations of formulas together.
So I was hoping some one would be able to help me write a formula that looks a bit like this
lookup a1, intabel1 a1:a100, return table1 f1:100 (if exact match a1 and in table 1 a1:a100) returns $ in table f1:f100 if not it returns not found
Is this possible?