Dave Liesse has written on 2/10/2014 4:00 PM: > The first problem I see is that your lookup value -- in this case the ID > number -- has to be the first column in the lookup array.
Interesting. I don't think I've ever seen that stated. > Using your specific example, the VLOOKUP function would be used in > column E of Sheet 2. So I type the VLOOKUP into a cell in E. Where do I enter the ID code? > This can be set up in advance, but you'll need to use an exact lookup > unless you know you exact lookup range ahead of time (in which case you > don't need to worry about searching an empty area). ??? Is there a problem if I overstate the size of the lookup area??? Thanks. > On 2/10/2014 12:03, Pikov Andropov wrote: >> 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: [email protected] 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
