Index help

[BROWNO1234]

hi,
I wonder if someone can help me ...i am using the index function to retrieve information of another sheet, basically i have a Inumbr on both sheets and i want to look this up on the backups tab and bring back each 'WHslot01'.
I am using =INDEX(Backups!$H$2:$H$3000,LARGE((B12=Backups!$C$2:$C$3000)*ROW(Backups!$C$2:$C$3000),COUNTIF(Backups!$C$2:$C$3000,B12)-Backups!$G$2:$H$3000+-1)-1)

I obviosuly change the -1 value to pick up the next location for the inumbr....what is happening and i dont quite know why is somtimes i am getting the Index to look up in the table and not pick the next location if that makes sense...

Surely there is an easier way of bringing back the data i want....
I have attached the workbook for your help

[NBVC]

I am not quite sure what you are using this part for as your k factor?

COUNTIF(Backu ps!$C$2:$C$3000,B12)-Backups!$G$2:$H$3000+-1)-1)

[BROWNO1234]

i am lost myself......i had someone write this formula years ago ...

Any help would be greatly appreciated

[NBVC]

You will have to explain the logic you want. I can only guess that perhaps for each Skorby Comm sheet you want to find the next match in the Backups sheet.

If so, in the first Skorby sheet, in K9 enter:

=INDEX(Backups!$H$2:$H$3000,MATCH(B9,Backups!$C$2:$C$3000,0))

copied down

in the 2nd sheet, in K9

=INDEX(Backups!$H$2:$H$3000,SMALL(IF(Backups!$C$2:$C$3000=B9,ROW(Backups!$C$2:$C$3000)-ROW(Backups!$C$2)+1),2))

confirmed with CTRL+SHIFT+ENTER not just ENTER

in the 3rd sheet:

=INDEX(Backups!$H$2:$H$3000,SMALL(IF(Backups!$C$2:$C$3000=B9,ROW(Backups!$C$2:$C$3000)-ROW(Backups!$C$2)+1),3))

confirmed with CTRL+SHIFT+ENTER not just ENTER and copied down.

Similar for other columns and/or additional sheets...

[BROWNO1234]

that worked great
ta

[BROWNO1234]

hi,
How do i use the print parameters ,what i want to do is no matter what data is in the Skorby comm tab i just print what is the cells for example ....data is only in upto cell A189...and b189 etc....if this increased or decreased it will just print what is required

Thanks for all your help