Is there a way to create a fomular that you can use to find a partular data
item, if located insert lets say a date in the column next to the found item?

Thanks

Frank

for finding particular data you can use a lot of formulas, ranging
from IF statements, VLOOKUP, HLOOKUP, LOOKUP, OFFSET, INDEX, MATCH,
FIND, SEARCH .....
to insert as well the same thing applies, so you may want to clarify
more what you want to do? put a sample of your data, so we can see
what is going arround?

Regards, Totti

Hi,

Formulas don't move to cells. You would need a. use VBA, b. enter formulas
in the adjacent column before hand. Beyond that you will need to give us a
lot more detail, preferably with sample data.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Frabj" wrote:

Is there a way to create a fomular that you can use to find a partular data
item, if located insert lets say a date in the column next to the found item?

Thanks

Frank