EXCEL help - using 'LOOKUP' I think but I could be barking up the wrong tree

[Katymac]

I have a list of names

I have a second list of names with a times attached

I would like the first list to have the times attached

Assuming the klists are in different order......how do I do this

If someone could explain in fairly simple terms I would appreciate it

bump

You need to use the vlookup function. If you use the function wizard (the fx button) it talks you through it.

Have an empty column to the right of the values on list one and click on the fx function button & choose vlookup. Then:

The first value you enter is the value you want to look up e.g assuming your values are in column A and you have a heading in cell A1, then you want to be putting the vlookup function in (empty) cell B2 and entering A2 as the first value in your vlookup wizard.

The second value is the range you want to look up against (i.e. highlight both columns in list 2), the 3rd value will be the column you want to return i.e. column "2" and for the 4th value type "null" (without the inverted commas in both cases!)

Hope this makes sense!

i.e. in a blank cell in your first list, type (making sure you type the brackets and the commas):

=VLOOKUP(click on cell in the first list that contains the name you want to find in the second list,click and drag to highlight the range of cells in the second list that contain the names and the information you want to return to your blank cell,type the number of the column that contains the time you want to insert next to the name in the first list)

Assuming you get the correct value, copy this formula down the rest of your column in the first list.

If you make the second list longer at any time, make sure you ament the range of cells to lookup in the formula.

Thank you - the good news is that that works

The bad news is that the formula changes each time I copy it - which is fine as far as the first entry goes but for the table array it all goes a bit squiffy

Is there any way I don't have to write it in each time?

Sorted it - I just name the range
(I think??)

Well it worked

Or fix the range by putting $ before the column and row numbers in the array.

I love vlookup. And pivot tables. Saddo.

Oh I always wondered what they were for - thanks

Do you dance btw? (the name.......)