Remember Me?

#1
May 1st 08, 05:53 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 493
Vlookup with the result being once cell below the orginal value

Hi

I have a vlookup in which I wanted to return the value for the cell right
below what would have the orginal cell.

This is the Formula I have. The result will return the value in E100 since
the value looking is in A100. I want the resulting value to be in E101

=VLOOKUP(\$M2,Sheet1!\$A\$10:\$H\$4009,5,FALSE)

Any assistance is appreciated.

#2
May 1st 08, 05:59 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Aug 2006 Posts: 3,268
Vlookup with the result being once cell below the orginal value

=INDEX(E10:E4009,MATCH(M2,A10:A4009,0)+1)

--

Regards,

Peo Sjoblom

"Alex" wrote in message
...
Hi

I have a vlookup in which I wanted to return the value for the cell right
below what would have the orginal cell.

This is the Formula I have. The result will return the value in E100
since
the value looking is in A100. I want the resulting value to be in E101

=VLOOKUP(\$M2,Sheet1!\$A\$10:\$H\$4009,5,FALSE)

Any assistance is appreciated.

#3
May 1st 08, 06:00 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 10,124
Vlookup with the result being once cell below the orginal value

Use MATCH to find the row and then incorporate into an INDEX formula. Look
in the help index for MATCH & INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alex" wrote in message
...
Hi

I have a vlookup in which I wanted to return the value for the cell right
below what would have the orginal cell.

This is the Formula I have. The result will return the value in E100
since
the value looking is in A100. I want the resulting value to be in E101

=VLOOKUP(\$M2,Sheet1!\$A\$10:\$H\$4009,5,FALSE)

Any assistance is appreciated.

#4
May 1st 08, 06:08 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Nov 2006 Posts: 15,768
Vlookup with the result being once cell below the orginal value

Try this:

=INDEX(Sheet1!\$E\$10:\$E\$4009,MATCH(\$M2,Sheet1!\$A\$10 :\$A\$4009,0)+1)

--
Biff
Microsoft Excel MVP

"Alex" wrote in message
...
Hi

I have a vlookup in which I wanted to return the value for the cell right
below what would have the orginal cell.

This is the Formula I have. The result will return the value in E100
since
the value looking is in A100. I want the resulting value to be in E101

=VLOOKUP(\$M2,Sheet1!\$A\$10:\$H\$4009,5,FALSE)

Any assistance is appreciated.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post kbee Excel Worksheet Functions 2 February 15th 08 09:45 AM Learning Excel 2007 Excel Discussion (Misc queries) 1 June 12th 07 09:12 AM Marie Excel Worksheet Functions 7 November 14th 06 03:52 AM Alyssa Excel Discussion (Misc queries) 1 March 8th 06 05:26 AM Shaynes Excel Discussion (Misc queries) 3 May 11th 05 11:24 PM

All times are GMT +1. The time now is 06:13 AM.