Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Vlookup hassles

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Alastair - 11 Dec 2003 02:57 GMT
Hello,
I was wondering how to lookup values to the right ,
instead of left of the column with the known variable in
it. This has me stumped!

Also I was wondering if anybody knows how to use a vlookup
function on a data table which has 1 column ascending and
1 descending. For presentation purposes the data must be
kept like it is and the numbers used have many decimal
places, so I cannot use the "false" range-lookup option,
which has been suggested to me already.

Thanks for your time, I will be very impressed if some one
knows the solution to these problems as they have plagued
myself and colleagues for many years.

Cheers

ALastair
J.E. McGimpsey - 11 Dec 2003 06:58 GMT
One way:

   =INDEX(A:A,MATCH(J1,B:B,FALSE))

Looks up the value in cell J1 in column B and returns the
corresponding cell in column A.

> I was wondering how to lookup values to the right ,
> instead of left of the column with the known variable in
> it. This has me stumped!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.