Vertical Lookup Formulas

[msmit8]

I'm trying to create a formula (I'm thinking I should be using a VLOOKUP formula) in my spreadsheet on cell K68 to display a different daily percentage that would exist in cell range F57:F80.

For example,
On 12/17, I want cell K68 to display 1%
On 12/18, I want cell K68 to display 2%
On 12/19, I want cell K68 to display 3%

12/17 - F57 = 1%
12/18 - F58 = 2%
12/19 - F59 = 3%

Hopefully this makes sense. Any suggestions would be appreciated.

Thanks!

 

[Akashwani]

Hi,

Yes you will need a Vlookup....

Excel Workbook
	A	B	C	D	E	F
1	Date	Data	Percentage		Lookup	Result
2	17/12/2012	F57	1.00%		19/12/2012	3.00%
3	18/12/2012	F58	2.00%
4	19/12/2012	F59	3.00%
Sheet1

Or an Index/Match....

Excel Workbook
	A	B	C	D	E	F
1	Date	Data	Percentage		Lookup	Result
2	17/12/2012	F57	1.00%		18/12/2012	2.00%
3	18/12/2012	F58	2.00%
4	19/12/2012	F59	3.00%
Sheet1

Obviously you will need to change the cell references to suit your layout.

I hope that helps.

Good luck.

Ak