M
mariekek5
I already got some advise on this matter (thanks Fred and Dave), but still I
do not get what I want.
Based on a L-number, I want to find the correct ID-number belonging to that
product from a specific supplier. So if I want the ID number from L-1234
belonging to supplier “Homer†… I would like to get the value “1237â€.
Using the following formula I get “8769â€â€¦which is the value from cell
A9…instead of A4.
=INDEX(A1:A9;MATCH(1;("L-1234"=B1:B9)*("Homer"=C1:C9)*0))
ID number L-number Supplier
1245 L-1234 Green
3456 L-1234 Smith
1237 L-1234 Homer
3456 L-3256 McDonald
2423 L-2435 Homer
7765 L-2222 Green
2543 L-2222 Smith
8769 L-5678 MCDonald
I hope someone can help me out here
Thanks in advance.
Regards,
Marieke
do not get what I want.
Based on a L-number, I want to find the correct ID-number belonging to that
product from a specific supplier. So if I want the ID number from L-1234
belonging to supplier “Homer†… I would like to get the value “1237â€.
Using the following formula I get “8769â€â€¦which is the value from cell
A9…instead of A4.
=INDEX(A1:A9;MATCH(1;("L-1234"=B1:B9)*("Homer"=C1:C9)*0))
ID number L-number Supplier
1245 L-1234 Green
3456 L-1234 Smith
1237 L-1234 Homer
3456 L-3256 McDonald
2423 L-2435 Homer
7765 L-2222 Green
2543 L-2222 Smith
8769 L-5678 MCDonald
I hope someone can help me out here
Thanks in advance.
Regards,
Marieke