Hi. In my workbook, I have sheet "Times" with the column headings Nomination, Code, House, Year, Gender, Event. All columns have entries and there are about 1400 rows.
In sheet "Field" I have the same columns. All columns are filled except Code.
I need to look in sheet "Field" and "remember" the entries across a row in all columns except Code.
Then I need to check in sheet "Times", work its way down the array until it finds the same unique match of entries. When it finds that, it needs to grab the corresonding entry in the Code column and return that entry in the Code column of sheet "Field".
I really hope this makes sense. What function do I need? I suppose it's a bit like a lookup with more than one column to check.
Thanks in advance for help with this one.
In sheet "Field" I have the same columns. All columns are filled except Code.
I need to look in sheet "Field" and "remember" the entries across a row in all columns except Code.
Then I need to check in sheet "Times", work its way down the array until it finds the same unique match of entries. When it finds that, it needs to grab the corresonding entry in the Code column and return that entry in the Code column of sheet "Field".
I really hope this makes sense. What function do I need? I suppose it's a bit like a lookup with more than one column to check.
Thanks in advance for help with this one.