excel macro formula help

  fox-knight 10:23 18 Jun 2009
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 2009

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 2009

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 2009

that will make it easier for the subsequent hero!

Regards,

Simsy

  VoG II 12:56 18 Jun 2009

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.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Illustrator Sylvain Tegroeg created thousands of intricate line drawings for the mobile game…

Best iPad buying guide 2017

Comment télécharger une application indisponible en France ?