Vlookup - Match - Index

[Khalil Handal]

Hi,
I need to know an explanation to each of the following formulas other than
that they gave the same result:

=AVERAGE(INDEX(SHEET1!I:J,MATCH($A$3,SHEET1!$B:$B,0)0))

=VLOOKUP($A$3,SHEET1!$B$14:$DO$83,18,FALSE)

COLOMN k Represented in number 18 is the average of I:J

 

[F.H. van Zelm]

Hi Khalil,

Is the setup of your question correct? Perhaps it is, but
- 18, counted from B gives column S, I think.
- INDEX, I think, returns one single cell. So what's the need of AVERAGE
around?
- Your first function doesn't function ... at least: it give an error with
me.
Shouldn't it be: =INDEX(Sheet1!I:J,MATCH($A$3,Sheet1!$B:$B,0),1) ?

Perhaps, try again.

Frans

 

[Adel Handal]

hi Van,
Sorry! instead of 18 it should be 10 (colomn K)
I will try you formula for index.