Thread
:
Want VLookup to Return the row above
View Single Post
#
9
Ron Rosenfeld
Posts: n/a
On 23 Apr 2005 07:49:46 -0700, "JoOwl0" wrote:
=INDEX(D4:G1358,MATCH(G1360,D4:D1358,0)-1,COLUMNS(D1:G1))
Thanks, Ron, it worked a charm!
Glad to help. Thanks for the feedback
--ron
Reply With Quote