Discussion Locked
Help Using Lookup In Excel2000
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone help?
Is it possible to lookup a vaulue in a column then search a row for a item and pick out the value for both.
e.g. I have a spreadsheet that has products in the column and panels on the top row. I want to find out the pallet qty so need to lookup both the product and the panel ref to get the pallet qty.......