Re: Retrieve data in a cell from value in another cell

Alright. I did more research and found the following equation, which is entered into cell E5 from Shop List worksheet:

{=IF(ISERROR(INDEX(Inventory!$C$4:$D$33,SMALL(IF(Inventory!$C$4:$C$33="x",ROW(Inventory!$C$4:$C$33)),ROW(Inventory!1:1)),2)),"",INDEX(Inventory!$C$4:$D$33,SMALL(IF(Inventory!$C$4:$C$33="x",ROW(Inventory!$C$4:$C$33)),ROW(Inventory!1:1)),2))}

However, the 1st item is spam when it should be eggs. Also, there are items that dont have an "x" in the column next to it that appear in the Shop List (That is not needed to purchase). FYI - I entered "x" into the column to the left of the inventory list, such that the above formula would carry out.

Please Advise on a solution.

THANKS!!