BIG question!

[newbie_excel]

Hi Guys, hope someone can help me out here!
OK here's the problem. My sheet looks like this:

A B C
21/07 tester 1
22/07 tester 2
21/07 tester b
23/08 tester 4
23/03 tester c

Where values in column A are dates, column B are usernames and C are membership types.
I want to create a formula which I can put onto a new sheet so that if values in column C are numbers above 2 (currently using 1, 2, 3 & 4) or letters (currently using a, b or c) then the cell with the formula displays the date and the username.

Hope you understand what I'm after!

 

[mikerickson]

=IF(INDEX(Sheet1!C:C,row(),1))>2,INDEX(Sheet1!AA,row(),1)&INDEX(Sheet1!BB,row(),1),"")

 

[dave3009]

Hi There

If the C column could be changed then you could use VLOOKUP for that

Say your range (As above but with C now in A) was A2:C7

Then in your new sheet B2 have

=VLOOKUP($A2, Sheet1!$A$2:$C$7, 2, 0)

And change that 2 to 3 for username

HTH


Dave