Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 9
There are 1 users currently browsing forums.
|
 |
05-15-2009, 02:30 PM
|
|
Registered User
|
|
Join Date: 25 Jan 2009
Location: NY
MS Office Version:Excel 2003 SP3
Posts: 24
|
|
Variation from Vlookup, cannot match rightmost column
Please Register to Remove these Ads
I am currently using VLOOKUP taking the data in column A and matching it to a worksheet which also has a matching number in columnA. Then populating fields in the first worksheet based on the position of the desired data. Works great.
However, I found out that the data MUST be the first column! I have a field that I need to do the same type of match but, it cannot be in the first column in the worksheet. There must be a way to do this! Added an illustration which probably makes this a little clearer.
Last edited by gia42; 05-20-2009 at 10:35 AM.
Reason: resolved
|
05-15-2009, 02:33 PM
|
 |
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,503
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
05-15-2009, 02:46 PM
|
|
Registered User
|
|
Join Date: 25 Jan 2009
Location: NY
MS Office Version:Excel 2003 SP3
Posts: 24
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
I am confused. I posted this in worksheet functions. I didn't at least intentionally post it on any other forums. What or how did I do it wrong?
|
05-15-2009, 02:49 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,503
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
I will move it for you...
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
05-15-2009, 02:51 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,503
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
I am kind of confused about your setup, etc.. but the alternative to Vlookup to look leftwards is Index/Match
e.g.
=Index(A1:A10,Match(X1,B1:B10,0))
where X1 needs to be matched to item in column B, but extract from column A...
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
05-18-2009, 08:15 PM
|
|
Registered User
|
|
Join Date: 25 Jan 2009
Location: NY
MS Office Version:Excel 2003 SP3
Posts: 24
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
The example I gave you was terrible. I am part of the way there, but still having trouble. Here is my current function, which yeilds an error #N/A.
=INDEX(G2:G10,MATCH(APPTABLE!H3,H3:H50,0))
The data to match is in column G in a worksheet named "application rem". The data I want is in another worksheet named "apptable". The matching value is in column A. The data I am attempting to pull in is in column H.
Can you tell me how to successfully point to the data in the other worksheet?
|
05-18-2009, 08:55 PM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,503
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
Probably:
=INDEX('application rem'!H3:H50,MATCH(APPTABLE!G3,'application rem'!A3:A50,0))
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
05-20-2009, 10:34 AM
|
|
Registered User
|
|
Join Date: 25 Jan 2009
Location: NY
MS Office Version:Excel 2003 SP3
Posts: 24
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
Thank you so much. Now I understand how this function is supposed to work! The help document makes it so much more difficult than it is! I really appreciate your quick responses and helpful information. The scales won't let me click on your reputation. Said I need to spread it around more first! Not fair!
|
05-20-2009, 10:50 AM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,503
|
|
|
Re: Variation from Vlookup, cannot match rightmost column
Quote:
Originally Posted by gia42
Thank you so much. Now I understand how this function is supposed to work! The help document makes it so much more difficult than it is! I really appreciate your quick responses and helpful information. The scales won't let me click on your reputation. Said I need to spread it around more first! Not fair!
|
You are welcome...
Yeah, the whole reputation system is flawed anyways.. so don't worry about.. but thanks for the thought and consideration. 
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
