Hey Everyone. I am stuck on this formula I created. I want to type an item number into B4 and if it matches, I want the info from column E and G to show in B2 and C2. I have come up with a formula that will show the info from column F, but I cannot figure out how to get the info from column G to show in column C. Any help is appreciated.

Thanks all.


Item Search.xlsx