VERY new with Excel and have a question I'm sure you'll find basic. I have two worksheets. In one worksheet, column G has text in it and included in the text is an item number. On the second worksheet, column A has just the item number and column B has the item name. What I'd like to be able to do is have a formula on column H of the first workbook that will look at column G and column A of the second worksheet and when the number in G matches in A, fills in the item name in column B of the second worksheet.
My head hurts even asking that question. Any ideas?