How to get the Old value of a lead status

Question

Do we have an option to get the old value of a lead status and update the same value?

I tried out using the Lead history option .But the issue is in the lead status picklist value we have different values which are dependent on the other.so can we track even does values ,because those fields are mandatory.

For Example:

In lead Status --the old value was as "Reengage" and got changed to new value as "Item Updated".So lead history it shows the value of old and new.But when the value was "Reengage" ,it was interlinked with other two fields ,so i would like to retrieve those values also.

Do we have an option.How to get it.There are nearly 4k records which got updated and would like to retrieve their values. Any help very much appreciated.

Answer 1

The answer to your question significantly depends on your edition as well as how and where you want to see that information:

1. a report
2. a visual force page (e.g. for use in a page-layout)
3. a query in the console (since you're an admin)
4. an export (via DataLoader) — if it's more of a one-time operation

For the future, consider Reporting Snapshots that you need to define prior to any subsequent reporting on historical data (or in this case snapshots thereof).

Addendum

Based on your comment:

I wanted to Update the Lead Owner Using The dataloader. But Instead of updating the Owner the lead status got changed. Now i would like to get the lead status of previous one.

First of all, that is the most crucial information your OP would highly benefit from mentioning.

To me, it sounds like 4. above is the way to go, so you:

1. export your lead history data using dataloader
2. filter out those changed in a given time frame
3. set those records back to their previous value using dataloader