So I'm def not a power EXCEL user, but I've done some work on it, but not anything involving multiple sheet interactions. What I'm trying to do is when I key an item number into col. E sheet 1, it will look for the matching item number in sheet 2 col. C and then return in sheet 1 col. G the value of sheet 2 col. B of the matching item. Hopefully my attempt at attaching sheet 1 was successful. I frankly have no idea how to execute the formula nor even what to search- I have been searching for the last couple of hours and not turned anything up. Any help is much appreciated.
Cheers,
CP
Bookmarks