Vertical Vlookup! is it possible ?

[audrey]

Hello what I am trying to do is if Apr is found (via match or vlookup formula), take the one value in one cell down!
Is that poissble ?

 

[njimack]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec		Apr
2	51	47.7	44.7	42	0	0	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!	#DIV/0!		42
Sheet1

 

[Jon von der Heyden]

You could try HLOOKUP:

=HLOOKUP("Apr",A1:L2,2,FALSE)

 

[audrey]

thanks guys both works great!

 

[Ruddles]

Just to clarify, VLookup is a vertical lookup.

What you wanted was a horizontal lookup (HLookup).