Hello,
Need you expert help
I want to compare a cell with a range and return TRUE if the value of the cell is in that range.
The problem is that I'm using huge tables... Excel limit... and using formulas is really really slow.
so, for example, I would have in Sheet 1 in A column
Cell 1
Cell 2
Cell 3
Cell 4
.
.
.
Cell X
and I need to compare each of these sells with Sheet 2 range of cells
Cell 1
Cell 2
Cell 3
Cell 4
.
.
.
Cell X
and return in Sheet 1 in Column B TRUE if Cell from sheet 1 is in Range of Cells in Sheet2.
The cells can be numbers or text... I mean some times I compare numbers... sometimes text...
Thank you in advance!
Bookmarks