jeudi 15 janvier 2015

using =if and Cell in the same formula?

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