Matt Campbell
New Member
- Joined
- Jun 2, 2008
- Messages
- 7
Hello,
I have a Sheet 1 with an Item Number and a corresponding value for that Item Number. If the corresponding value is greater than 0, I want Excel to search Sheet 2. Sheet 2 contains a list of Item Numbers. If the Item Number does not appear on Sheet 2, I want an "N/A" to appear on the first sheet. I hope I explained that well enough. Can anyone help me out with this?
- Matt
I have a Sheet 1 with an Item Number and a corresponding value for that Item Number. If the corresponding value is greater than 0, I want Excel to search Sheet 2. Sheet 2 contains a list of Item Numbers. If the Item Number does not appear on Sheet 2, I want an "N/A" to appear on the first sheet. I hope I explained that well enough. Can anyone help me out with this?
- Matt