Single cell is preferable, but I can make do with separate cells. I know it
is probably very easy to do, but did you forget to divulge the formula here?

Thanks for your response.

rc


"Biff" wrote:

Hi!

So, let's say we find "bb1" at Entry!F30 and F59. The values contained in
Entry!A30 and A59 need to display in BestBallA4.

Easily done if you put the results in separate cells. If you want all of the
results to appear in a single cell, good luck!

Biff

"rc" wrote in message
...
I'm trying to populate a new worksheet by flagging cells in a previous
worksheet. Specifically, populate the first column of worksheet named
BestBall using this logic:

If Entry!F4:F154 = "bb1", then grab value of column A and display in first
column of BestBall.

So, let's say we find "bb1" at Entry!F30 and F59. The values contained in
Entry!A30 and A59 need to display in BestBallA4.


Thank you,

rc