View Full Version : Solved: Row After Vlookup
wadirks
12-09-2012, 05:57 PM
I want to know the row() where the results of a vlookup() were found. Preferably without using a macro. Something like: =ROW(VLOOKUP(NamedCell,NamedRange,1,FALSE)), which of course does not work. Your suggestions would be appreciated.
mikerickson
12-09-2012, 08:14 PM
The Match function
=MATCH(NamedCell,NamedRange,0) + ROW(NamedRange) -1
wadirks
12-10-2012, 08:34 AM
Exactly what I needed. Thank you.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.