Question Locked

Excel Look Up

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to take 2 worksheets and be able to insert information regarding specific cells from one to the other. 1 worksheet has our inventory items listed and the Quantities used in a given time - the other worksheet has all the inventory item descriptions and data but does not include quantities. I want to be able to make worksheet that will include information regarding each line item and will have both worksheets information combined.

2 replies

by locolobo

It should do the trick. If you data is horizontal you could try HLOOKUP instead.

This discussion is closed to new replies.