Got about the same, but MUST be confirmed with Ctrl+Shift+Enter. In O6 and down:
=LOOKUP(N6, IF(($A$1:$A$61=$K6)*($B$1:$B$61=$M6)*($C$1:$C$61=N$5), $E$1:$E$61), $D$1:$D$61)
Copy to Q6 and down.
Got about the same, but MUST be confirmed with Ctrl+Shift+Enter. In O6 and down:
=LOOKUP(N6, IF(($A$1:$A$61=$K6)*($B$1:$B$61=$M6)*($C$1:$C$61=N$5), $E$1:$E$61), $D$1:$D$61)
Copy to Q6 and down.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks