I have four columns (A, b, c, d). What could I do to have each cell in "A"
check all cells in "B" to see if their is a match. If there is a match in
"C" take the value in "D" and place it in "B" next to the match in column "A".
Unit(A) #of Admissions(B) Unit(C) #of
admissions(D)
CCU 5 TICU
2
ICU CCU
5
TICU ICU
4

Goal: I want to populate "B" with the information from "D" next to the
correct unit.

Thank you,
Kem