I'm trying to find a way to return the location of the results of a Vlookup. To try to simplify this, I want a formula to do a Vlookup and for another formula to be able to report what cell number the Vlookup is referring to when it finds what it is looking for. Does anyone have any suggestions?
the Match() function will give you the vertical position within the range that a match is found.
e.g. =Match(A1,X1:X100,0) where A1 is the look up value (same as your Vlookup) and X1:X100 is the column range to find the look up value (the first column of your Vlookup table).
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks for the tip, as I've never heard of the "match" function before, but is there a way to use it to return the cell location (e.g. a1, c3, etc.) instead of the cell position?
Originally Posted by NBVC
If you're using Vlookup...you probably know the column to pull from...so you can probably use Address function....
e.g. =Address(Match(A1,X1:X100,0),3)
where 3 is the column number (starting count from column A) where the Vlookup pulled value would be coming from...
Note: The range within the match function must start at row 1 (or you can add the number of rows you offset by at the end of the Match function---eg. =Match(A1,X5:X100,0)+4
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks