I have an inventory workbook with 3 tabs ("Count Sheet", "Report A", "Report B") we enter the inventory on the "Count Sheet", and I need to generate a formula to search that sheet for a value and return the value in an adjacent cell eg: search "count sheet" for "Widget 1" return "number on hand 2 cells to the right" so all the search terms will be in Column C and all all the counts will be in Column H any ideas on a simple / easy way to do this?

Thanks

TJ