Easier way to write down this formula

Formula:

INDEX(Blad1!$A$1:$A$65001;Blad1!$C$1:$C$65001;Blad1!$E$1:$E$65001;Blad1!$G$1:$G$65001;Blad1!$I$1:$I$65001;Blad1!$K$1:$K$65001;Blad1!$M$1:$M$65001;Blad1!$O$1:$O$65001;Blad1!$Q$1:$Q$65001;Blad1!$S$1:$S$65001;Blad1!$U$1:$U$65001;Blad1!$W$1:$W$65001;Blad1!$Y$1:$Y$65001;Blad1!$AA$1:$AA$65001;Blad1!$AC$1:$AC$65001;Blad1!$AE$1:$AE$65001;Blad1!$AG$1:$AG$65001;Blad1!$AI$1:$AI$65001;Blad1!$AK$1:$AK$65001;Blad1!$AM$1:$AM$65001;Blad1!$AO$1:$AO$65001;Blad1!$AQ$1:$AQ$65001;Blad1!$AS$1:$AS$65001;Blad1!$AU$1:$AU$65001;Blad1!$AW$1:$AW$65001;Blad1!$AY$1:$AY$65001;Blad1!$BA$1:$BA$65001;Blad1!$BC$1:$BC$65001;Blad1!$BE$1:$BE$65001;Blad1!$BG$1:$BG$65001;Blad1!$BI$1:$BI$65001;Blad1!$BK$1:$BK$65001;Blad1!$BM$1:$BM$65001;Blad1!$BO$1:$BO$65001;Blad1!$BQ$1:$BQ$65001;Blad1!$BS$1:$BS$65001;Blad1!$BU$1:$BU$65001;Blad1!$BW$1:$BW$65001;Blad1!$BY$1:$BY$65001;Blad1!$CA$1:$CA$65001;Blad1!$CC$1:$CC$65001;Blad1!$CE$1:$CE$65001;Blad1!$CG$1:$CG$65001;Blad1!$CI$1:$CI$65001;Blad1!$CK$1:$CK$65001;Blad1!$CM$1:$CM$65001;Blad1!$CO$1:$CO$65001;Blad1!$CQ$1:$CQ$65001;Blad1!$CS$1:$CS$65001;Blad1!$CU$1:$CU$65001;Blad1!$CW$1:$CW$65001;Blad1!$CY$1:$CY$65001;Blad1!$DA$1:$DA$65001;Blad1!$DC$1:$DC$65001;Blad1!$DE$1:$DE$65001;Blad1!$DG$1:$DG$65001;Blad1!$DI$1:$DI$65001;Blad2!$A$1:$A$65001;Blad2!$C$1:$C$65001;Blad2!$E$1:$E$65001;Blad2!$G$1:$G$65001;Blad2!$I$1:$I$65001;Blad2!$K$1:$K$65001;Blad2!$M$1:$M$65001;Blad2!$O$1:$O$65001;Blad2!$Q$1:$Q$65001;Blad2!$S$1:$S$65001;Blad2!$U$1:$U$65001;Blad2!$W$1:$W$65001;Blad2!$Y$1:$Y$65001;Blad2!$AA$1:$AA$65001;Blad2!$AC$1:$AC$65001;Blad2!$AE$1:$AE$65001;Blad2!$AG$1:$AG$65001;Blad2!$I$1:$AI$65001;Blad2!$AK$1:$AK$65001;Blad2!$AM$1:$AM$65001;Blad2!$AO$1:$AO$65001;Blad2!$AQ$1:$AQ$65001;Blad2!$AS$1:$AS$65001;Blad2!$AU$1:$AU$65001;Blad2!$AW$1:$AW$65001;Blad2!$AY$1:$AY$65001;Blad2!$BA$1:$BA$65001;Blad2!$BC$1:$BC$65001;Blad2!$BE$1:$BE$65001;Blad2!$BG$1:$BG$65001;Blad2!$BI$1:$BI$65001;Blad2!$BK$1:$BK$65001;Blad2!$BM$1:$BM$65001;Blad2!$BO$1:$BO$65001;Blad2!$BQ$1:$BQ$65001;Blad2!$BS$1:$BS$65001;Blad2!$BU$1:$BU$65001;Blad2!$BW$1:$BW$65001;Blad2!$BY$1:$BY$65001;Blad2!$CA$1:$CA$65001;Blad2!$CC$1:$CC$65001;Blad2!$CE$1:$CE$65001;Blad2!$CG$1:$CG$65001;Blad2!$CI$1:$CI$65001;Blad2!$CK$1:$CK$65001;Blad2!$CM$1:$CM$65001;Blad2!$CO$1:$CO$65001;Blad2!$CQ$1:$CQ$65001;Blad2!$CS$1:$CS$65001;Blad2!$CU$1:$CU$65001;Blad2!$CW$1:$CW$65001;Blad2!$CY$1:$CY$65001;Blad2!$DA$1:$DA$65001;Blad2!$DC$1:$DC$65001;Blad2!$DE$1:$DE$65001;Blad2!$DG$1:$DG$65001;Blad2!$DI$1:$DI$65001;Blad2!$EA$1:$EA$65001;Blad2!$EC$1:$EC$65001;Blad2!$EE$1:$EE$65001,MATCH(A1,Blad1!$B$1:$B$65001;Blad1!$D$1:$D$65001;Blad1!$F$1:$F$65001;Blad1!$H$1:$GH$65001;Blad1!$J$1:$J$65001;Blad1!$L$1:$L$65001;Blad1!$N$1:$N$65001;Blad1!$P$1:$P$65001;Blad1!$R$1:$R$65001;Blad1!$ST$1:$T$65001;Blad1!$V$1:$V$65001;Blad1!$X$1:$X$65001;Blad1!$Z$1:$Z$65001;Blad1!$AB$1:$AB$65001;Blad1!$AD1:$AD$65001;Blad1!$AF$1:$AF$65001;Blad1!$AH$1:$AH$65001;Blad1!$AJ$1:$AJ$65001;Blad1!$AL$1:$AL$65001;Blad1!$AN$1:$AN$65001;Blad1!$AP$1:$AP$65001;Blad1!$AR$1:$AR$65001;Blad1!$AT$1:$AT$65001;Blad1!$AV$1:$AV$65001;Blad1!$AX$1:$AX$65001;Blad1!$AZ$1:$AZ$65001;Blad1!$BB$1:$BB$65001;Blad1!$BD$1:$BD$65001;Blad1!$BF$1:$BF$65001;Blad1!$BH$1:$BH$65001;Blad1!$BJ$1:$BJ$65001;Blad1!$BL$1:$BL$65001;Blad1!$BN$1:$BN$65001;Blad1!$BP$1:$BP$65001;Blad1!$BR$1:$BR$65001;Blad1!$BT$1:$BT$65001;Blad1!$BV$1:$BV$65001;Blad1!$BX$1:$BX$65001;Blad1!$BZ$1:$BZ$65001;Blad1!$CB$1:$CB$65001;Blad1!$CD$1:$CD$65001;Blad1!$CF$1:$CF$65001;Blad1!$CH$1:$CH$65001;Blad1!$CJ$1:$CJ$65001;Blad1!$CL$1:$CL$65001;Blad1!$CN$1:$CN$65001;Blad1!$CP$1:$CP$65001;Blad1!$CR$1:$CR$65001;Blad1!$CT$1:$CT$65001;Blad1!$CV$1:$CV$65001;Blad1!$CX$1:$CX$65001;Blad1!$CZ$1:$CZ$65001;Blad1!$DB$1:$DB$65001;Blad1!$DD$1:$DD$65001;Blad1!$DF$1:$DF$65001;Blad1!$DH$1:$DH$65001;Blad1!$DJ$1:$DJ$65001;Blad2!$B$1:$B$65001;Blad2!$D$1:$D$65001;Blad2!$F$1:$F$65001;Blad2!$H$1:$H$65001;Blad2!$J$1:$J$65001;Blad2!$L$1:$L$65001;Blad2!$N$1:$N$65001;Blad2!$P$1:$P$65001;Blad2!$R$1:$R$65001;Blad2!$T$1:$T$65001;Blad2!$V$1:$V$65001;Blad2!$X$1:$X$65001;Blad2!$Z$1:$Z$65001;Blad2!$AB$1:$AB$65001;Blad2!$AD$1:$AD$65001;Blad2!$AF$1:$AF$65001;Blad2!$AH$1:$AH$65001;Blad2!$J$1:$AJ$65001;Blad2!$AL$1:$AL$65001;Blad2!$AN$1:$AN$65001;Blad2!$AP$1:$AP$65001;Blad2!$AR$1:$AR$65001;Blad2!$AT$1:$AT$65001;Blad2!$AV$1:$AV$65001;Blad2!$AX$1:$AX$65001;Blad2!$AZ$1:$AZ$65001;Blad2!$BB$1:$BB$65001;Blad2!$BD$1:$BD$65001;Blad2!$BF$1:$BF$65001;Blad2!$BH$1:$BH$65001;Blad2!$BJ$1:$BJ$65001;Blad2!$BL$1:$BL$65001;Blad2!$BN$1:$BN$65001;Blad2!$BP$1:$BP$65001;Blad2!$BR$1:$BR$65001;Blad2!$BT$1:$BT$65001;Blad2!$BV$1:$BV$65001;Blad2!$BX$1:$BX$65001;Blad2!$BZ$1:$BZ$65001;Blad2!$CB$1:$CB$65001;Blad2!$CD$1:$CD$65001;Blad2!$CF$1:$CF$65001;Blad2!$CH$1:$CH$65001;Blad2!$CJ$1:$CJ$65001;Blad2!$CL$1:$CL$65001;Blad2!$CN$1:$CN$65001;Blad2!$CP$1:$CP$65001;Blad2!$CR$1:$CR$65001;Blad2!$CT$1:$CT$65001;Blad2!$CV$1:$CV$65001;Blad2!$CX$1:$CX$65001;Blad2!$CZ$1:$CZ$65001;Blad2!$DB$1:$DB$65001;Blad2!$DD$1:$DD$65001;Blad2!$DF$1:$DF$65001;Blad2!$DH$1:$DH$65001;Blad2!$DJ$1:$DJ$65001;Blad2!$EB$1:$EB$65001;Blad2!$ED$1:$ED$65001;Blad2!$EF$1:$EF$65001,0))

It looks up a number in a file and gives a value out of the column left of the number.
Anybody?

This would be a simplified version of the same kind of formula.

Formula:

=INDEX($C$3:$C$7, MATCH(A11,$B$3:$B$7,0))

But in my example i have many more columns and rows in which i want to lookup a value and give the number in the column next to the value.

Let me state it this way, i would like use this formula:

=INDEX($C$3:$C$7 but also $E$3:$E$7 (not $D$3:$D$7), MATCH(A11,$B$3:$B$7 and $D$3:$D$7,0))

How would you write this down?

Hi,

I have made an attachment.

You've a sheet with numbers and values.

In the sheet 'What', i've numbers which i would like to match.

And in the Sheet 'How it should be' it lists the 'Values' left of the numbers.

So how would this index/match function look like, remember the real data set is much larger.

Thnx.

You are wright about the F2 function. But could you rewrite the formula with the same kind of document, but with more columns and rows? The rows end at 65001 and the columns at RJ. Is this possible and how would you rewrite this?

I made an attachment.

And split the number and values over the sheet. So now i want to find the number in the sheet 'numbers' in cell A1 and it should return the cell A1 from sheet 'values'.

Is this maybe a possibility?