Search function in database

[tpedry]

I am not sure if this is possible, but can you search a column and bring up results. I realize this is more of an access function, but it would be very handy for what I am assembling here.

On my 'Material Items' sheet, in column B, I would like to be able to search using a 'key word'. Unfortunately, I am also using Excel on a Mac, so I know there are some limitations.

See attached

Thank you for your help.

Tim

[azumi]

I don't know workin or not in Mac, just try it, I put formula in Sheet1, and search keyword in cell A2

[tpedry]

Absolutely beautiful!!!!! Wow, that was like a christmas present!!! God Bless you!!