I am trying to set up a budget worksheet and I want to enter amount of an Item on another worksheet if it contains certain text in different column. This is what it looks like:
(Sheet1) Cell E3:Mac Laptop
(Sheet1) Cell H3:$1600
(Sheet2) Want to enter the amount of the item if Laptop is in the Cell. So basically search Cell E3 on sheet1 for "Laptop" if true then enter data from Cell H3 from sheet1. This needs to be done for whole columns of E and H. So if we search anything in E then if true will return value from corresponding row in column H. Thanks
Bookmarks