Excel 2007 : How to attain matching

[APPLEBEE]

hi
Gurus

i have a column with dynamic values, they may change depending on the user input

say from a1 to a25
each cell is dynamic subject to user input (monthname)


i have two columns with values


column i column j
may a
june b
july c
augusta d
september e
october f
november g
december h
january i
february j



now based on the user input (month)

i would like to get the values in column j


please advice

thanks

[NBVC]

Isn't it just

=Vlookup(A1,$I$1:$J$12,2,FALSE)

where I1:I12 contain the lookup table.

[APPLEBEE]

Isn't it just

=Vlookup(A1,$I$1:$J$12,2,FALSE)

where I1:I12 contain the lookup table.

yes thanks for ur reply
but i did that and i see no wrong in it , well the result is #ref in each cell i applied this formula

please clarify

thanks

[NBVC]

What exact formula did you use?

Is the lookup table array wide enough to extract from the column number indicated?

[APPLEBEE]

What exact formula did you use?

Is the lookup table array wide enough to extract from the column number indicated?

=VLOOKUP(EI79,$DX$28:$DY$39,DY29,FALSE)

ei179 to ei365 contains the values that DYNAMICALLY CHANGE DEPENDING on the start month

below is the lookup table

DX28 DY29
----------------------------------------
MAY DMY
JUNE DJU
JULY DJY
AUGUST DAU
SEPTEMBER DSP
OCTOBER DOC
NOVEMBER DNV
DECEMBER DDC
JANUARY DJA
FEBRUARY DFB
MARCH DMR

thanks

[NBVC]

The DY29 should be 2:

=VLOOKUP(EI79,$DX$28:$DY$39,2,FALSE)

[APPLEBEE]

The DY29 should be 2:

=VLOOKUP(EI79,$DX$28:$DY$39,2,FALSE)

thank you v much

solved my problem

[APPLEBEE]

Hi
Gurus

I have this excel

where in i need to figure out a vlookup on set of values where i need to print the whole line that matches withthe cell value in d 22

for example if d 22 has dmy , i need a formula that looks at d8:d17 to find

DMY and bring the complete columns beside it


thanks

[NBVC]

You should be starting a new thread...

[APPLEBEE]

Hi
gurus

How to get this in excel 2007
my fiscal year starts in april
2. how can i achive a projects no of months if it is cross over years
for example a project starts in 2-2010 and ends in 3 2011

then the project falls in 2 fiscal years 2010 and 2011

now i need no of months in 2011 fiscal year which is 12 months
and 2 months in 2010

please let me know the formula to calculate this in excel

thanks

[NBVC]

Please start a new thread.