I have worked this for hours and the formula just isn't working. It is
pulling data, but in the wrong order. is there a way to send my file?

"mygsdsni" wrote:

Okay. I copied this formula in, found the worksheet and sheet number to
refer to and the formula changed to this
=INDEX([Names]Sheet2!$B$1:$B$100,MATCH(G2,[Names]Sheet2!$A$1:$A$100,0))

and the column reslts are #N/A

"Eduardo" wrote:

oopss i mix the columns use this

=INDEX(Names!$b$1:$b$100,MATCH(g2,Names!$a$1:$a$10 0,0))

"Eduardo" wrote:

Hi,
If you want to assign the name to the year, you need somewhere to have the
years and beside it the names, let's say that you have a worksheet called
Names and in column A you have the years and in column B the names you assign
then in your worksheet column H enter the formula

=INDEX(Names!$a$1:$a$100,MATCH(g2,Names!$B$1:$B$10 0,0))

copy the formula down



"mygsdsni" wrote:

Sure.

Column G are different years in no paricular order, i.e; 1997, 1999, 2002,
2008

I need column H to choose a name that is not listed in this worksheet,
rather one I assign so I am not sure that I can use vlookup, i.e; IF
1997"Voigt", IF 1998 "Voigt", IF 1999"Chifflard", IF 2000"Voigt", IF
2001"Voigt", IF 2002 "Wuttge" etc. There are a number of years and names.


"Eduardo" wrote:

Hi,
an example and the results you are looking for will help, thanks

"mygsdsni" wrote:

You can only add 7 conditions. What do you do if you have more then 7? Is
there another function?

Thanks,
Kristin