Thread
:
Want VLookup to Return the row above
View Single Post
#
6
Niek Otten
Posts: n/a
Sorry,
=INDEX(D4:G1358,MATCH(G1360,D4:D1358)-1,COLUMNS(D1:G1))
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"JoOwl0" wrote in message
ups.com...
Oops, that gives #NA.
=INDEX(D4:G1358,MATCH(G1360,D4:G1358)-1,COLUMNS(D1:G1))
But thanks anyway
Reply With Quote