Posted to microsoft.public.excel.worksheet.functions

Nick H[_2_] Nick H[_2_] is offline

external usenet poster

Posts: 11

Question on looking up data

I have a large table, and I am using VLOOKUP to find data. What I need is a
way to get Excel to return the value in the cell immediately below the one
that contains the value that VLOOKUP finds. For example, let's say
VLOOKUP(10,A1:C:200,2) returns a value from B50. The value I want is in B51;
how can I get that? Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data Table Question?	Bob	Excel Discussion (Misc queries)	2	June 3rd 09 02:09 AM
Data Validation Question	DonkeyKong	Excel Discussion (Misc queries)	4	December 29th 08 07:10 PM
Data Validation Question	jwags	Excel Discussion (Misc queries)	1	August 18th 08 06:23 PM
Fill data question	[email protected]	Excel Discussion (Misc queries)	3	July 17th 06 11:45 PM
Data parsing question	Dan Neely	Excel Worksheet Functions	0	July 19th 05 12:40 AM

All times are GMT +1. The time now is 09:36 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us