Try this..
INDEX/MATCH
Make sure there are no leading and following spaces..![]()
=Index(Result_Range,Match(B1, Lookup_Range, 0))
Try this..
INDEX/MATCH
Make sure there are no leading and following spaces..![]()
=Index(Result_Range,Match(B1, Lookup_Range, 0))
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks