I hope someone can help me. I am trying to use specific critirea to bring back cell information.
I have some raw data on Sheet 1, and on sheet 2 i have a list of references, i want to know if those references are in my raw data on sheet 1 and if so tell me what cell it is in.
the formula i have tried is: =IF(Sheet1!A:A=Sheet2!A1,Cell("row"),0)
This just brings back '0' all the time, even though i know the data is in sheet 1. Can anyone help me please?
Aucun commentaire:
Enregistrer un commentaire