data array with date range and return text value in result

jigarecity · Jan 27th 2021

HI,

Test file attached for formula of data array with date range and return text value in result ..

**royUK** · Jan 27th 2021

Not enough information to see what you mean

jigarecity · Jan 27th 2021

Hi roy

please see attached file

i need result in column C from data table

C2 cell is result mention ..

once again same file attached

**royUK** · Jan 27th 2021

Do you mean VLOOKUP?

bosco_yip · Jan 28th 2021

Maybe,

In C2, formula copied down :

=LOOKUP(B2,OFFSET(INDEX($I:$I,MATCH(A2,$G:$G,0)),0,0,4,3))

Participate now!