Thread: Looking to populate one sheet with conditional data from a different sheet

Hi -

I have SheetA and SheetB. I want to lookup any cells that contain "FoKM" in sheetA and return the text in a cell in sheetB, along with the given date in sheetA.

For example, SheetB will have "July 14, 2010" and "NY: Potential FoKM Session #8."

Any thoughts or insights on how best to do this?

Cheers,
K