Lookup using multiple columns

[rline101]

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.

 

[patrickmuldoon99]

You should use a Vlookup, but concatenate the columns that you are looking up into one field.

For example, imagine you had an address to find. In one sheet there is house number, address line 1, address line 2 etc...

you could put a formula in the adjacent cell to the address details, concatenating the values using the "&" symbol. You can then look up this single value by concatenating the value you are looking up .

Does this make sense to you?

 

[rline101]

patrickmuldoon99

thanks heaps for your ultra-quick reply. yes it makes perfect sense, I tried it and it works wonderfully.

Cheers!