Re: [libreoffice-users] Calc: help with VLOOKUP

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: 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