populating a cell from depending on the filter on wnother sheet

[kleaves]

Title should say: Populating a cell in a column from another sheet

I have a 2 column spreadsheet
Column 1 – Holds the correct status
Column 2 – Holds the old status

I have a filter set up on this so that when I select the old status, it shows me what the correct status should be.

I now have another work sheet, which has a list of data, one column is "Old Status". I have created a blank column next to this called – "Correct status" - What I want to do , is depending on what the old status is in Sheet 2, the new status is populated in the "correct status" column


How can I do this?

 

[Brianwarnock]

Is Vlookup what is needed?

 

[kleaves]

Populating a cell depending on the filter in another w/sheet

Thanks, Used Vlookup and it is exactly what I wanted

Thanks again