Why not just use named ranges as JE suggests?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Corben" wrote in message
...
Could I use a formula to look at a cell next to it and then return based
on
the text inside that cell?

ie: if A100 = "Group A", return contents of B100.

"JE McGimpsey" wrote:

Yes, unless you're using a named range.

In article ,
Corben wrote:

Do both workbooks have to be open?