You need to do two thinsg to make this work easily.

First, get rid of the merged cells in Report column B, and repeat the Item # in each row, looking back is a pain.

Second, add a lookup table of Whse codes against the value, to facilitate the lookup.