Search the help for the VLOOKUP function, that may be useful in this case.
It also have a parameter to perform the lookup on non sorted lists.

Hope this helps,
Miguel.

"Paula_p" wrote:

Hi everyone,
I have an invoice as one sheet and an inventory list as another sheet in the
same workbook. I would like to be able to select items from the inventory
list and have that info. (about 3 columns from 8) sent directly to the
invoice in order to generate a bill, however, the items are not necessarily
consecutive in the list. Is there a way to do this?
Thanks for any help!!