Something is not working for me. Hope someone can help.
I have a two-sheeted speadsheet.
Sheet 1 has three columns as follows:
A. Name
B. Price (ignorable as far as this example is concerned)
C. ID number
Sheet 2 has three columns as follows:
A. Item Code
B. Item description
C. Minimum bid (ignorable as far as this example is concerned)
The operator will be given a piece of paper with an Item code, an ID
number and a price. I would like him to be able to look up an Item code
in Sheet 2 and then, in that row, enter the ID number (column D?). A
VLOOKUP formula would paste the Name into an available column (E?) and
the operator would enter the price into the next column (F?).
Where do I type the =VLOOKUP formula?
Can I save the sheet with the formula so I can set this strategy up
ahead of time?
How do I get the formula to apply properly to every row?
What should the initial formula look like?
Thank you.
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted