VBA TIPS
Search by multiple value

Here is a basic formula for searching result by multiple value.

Input following formula and press [Ctrl] + [Shift] + [Enter].

=INDEX(C2:C4,MATCH(E1,A2:A4&" " &B2:B4,0))




| HOME |
Copyright © cellmasters.net - colo's junk room All Right Reserved
ABOUT
WORKS
THE CELL MASTERS
CONTACT
LINKS
Tips and Information about Microsoft Excel|Masaru Kaji aka Colo