formular for finding data and inserting value in seperate column

[Frabj]

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

 

[Totti]

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

 

[Shane Devenshire]

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