=INDEX(A1:B5, MATCH($D1,A1:A5,0),$E1)
A B C D E
kiwi 93 Oranges 25
Bananas 38 Bananas 38
Oranges 25 Apples 41
Apples 41 Oranges 25
Pears 40 Pears 40
Bananas 38
kiwi 93
Pears 40
I have one reference sheet ie col A & B and another which has Col D.
I consistently need to keep entering ?fruit? in column D in another worksheet (same wb). I want to match Oranges from Column D to same value in Column A and bring value B over to populate column E.
I have been playing around with Index and Match etc etc and cannot find the right combo.
This would be a HUGE time saver for me not to have to re-enter the same data hundreds of times!
