Searching for text strings in one cell, returning values from another

You'd normally use VLOOKUP for this. Attach a sample workbook then it will be easier to see where "Widget 1" is selected.

Hope this helps.

Pete

Test Workbook.xls

we are filling the "on hand count" column (currently just an =cell formula)In the Report sheets from the "count sheet" but we need to search for the name i specify... (note, widget 1 may not be called widget 1 on all sheets, will need to specify value in formula)

the reason for this is we may add rows or columns in any place on that count sheet or reorder it as time goes on but it still needs to fill out the report sheets correctly...


Thanks