Populate Column?

[DekHog]

Hi all...

In the attached workbook I need to populate column A (Sheet 1) based on the contents of column A (Sheet 2) using column B on both sheets as the index - can anyone help with this?

TIA

[davesexcel]

Try the auto filter

[DekHog]

Hi...

How is autofilter going to populate the column A on sheet 1? I need it populated with 1st, 2nd, 3rd or 4th to create a PivotTable, and I assume would therefore need a formula to copy down which refers to Sheet 2...

Thanks

[arthurbr]

Would this help ?
(It is adapted from this site :http://www.cpearson.com/excel/lookups.htm#LeftLookup)

[DekHog]

Would this help ?
(It is adapted from this site :http://www.cpearson.com/excel/lookups.htm#LeftLookup)

That would be absolutely perfect! Thank you.

[arthurbr]

Glad to help