I'm trying to enter a ref. in one sheet based on text data entered in another.
Being the Excel genius that I am, I came up with the following formula:
=IF('Purchase Day Book'!B31:B41,"Cinergi","PDB")
The result is "value" when I press enter.
I've tried to find an answer in the search, without success, but I've
enjoyed reading the other questions.
I'm wondering too, what will happen if "Cinergi" appears more than once
between
"B31:B41" in the other sheet.
Any ideas should be most welcome.
Gatsby (Not the Great)