excel macro formula help

  fox-knight 10:23 18 Jun 09
Locked

Hi Guys,
Can you help, i have 2 excel spreadsheets, 1 contains a user id, (in col h)but not the user name. The secon sheet contains the user name (in Col c) & user id (col e)

I am trying to compose a formula that will take the detail in row sheet 1 search for it in sheet 2 & then paste the corresponding name on sheet 1.

I can do this with a macro but how do i make this repeat for all other rows?

Thanks

Fox

  Simsy 10:36 18 Jun 09

I can can up with the code you seek... however, for the person that can you need to clarify something slightly...

When you say "2 excel spreadsheets", do you mean 2 worksheets in the same Excel file, or 2 different Exccel files.

It will make a difference to the code.

Regards,

Simsy

  fox-knight 10:43 18 Jun 09

originally these where separate spreadsheets but i have now copied the second one unto the first,

so they are now on 2 separate worksheets

  Simsy 10:51 18 Jun 09

that will make it easier for the subsequent hero!

Regards,

Simsy

  VoG II 12:56 18 Jun 09

No need for a macro.

In row 1 of Sheet1 and filled-down

=INDEX(Sheet2!C:C,MATCH(H1,Sheet2!E:E,0))

This thread is now locked and can not be replied to.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos