Is there a way of having a cell location returned. I am trying to check down a failry long list of entries and I need to know which row the item appears in.
For example... Data to be searched "ROBB"
A
1 EVANS
2 PETERS
3 ANDREWS
4 ROBB
5 MORGAN
I am looking to get something to report the data was found on row 4 or A4.
Thanks
For example... Data to be searched "ROBB"
A
1 EVANS
2 PETERS
3 ANDREWS
4 ROBB
5 MORGAN
I am looking to get something to report the data was found on row 4 or A4.
Thanks