invoice problem

I am trying to get all my information on one sheet with order#'s on each line
and then have worksheet #2 that has an invoice on it. Then I can put in the
order # in worksheet #2 and the info will flow from sheet 1 to sheet 2 that
involves that order #. Is this possible?

On Mon, 20 Mar 2006 10:18:54 -0800, lsent
<lsent@discussions.microsoft.com> wrote:

>I am trying to get all my information on one sheet with order#'s on each line
>and then have worksheet #2 that has an invoice on it. Then I can put in the
>order # in worksheet #2 and the info will flow from sheet 1 to sheet 2 that
>involves that order #. Is this possible?

Sounds like you need the ubiquitous =VLOOKUP function.

Assuming your order data on Worksheet 1has the order no. in column A,
Name the whole of the order data - say "Ord_Data"

Now on your invoice sheet, assuming the order number is entered in say
D1, and you need a particular field (say field 3) from the order data
in Sh 2 D5, enter in D5:

=VLOOKUP(D1,Ord_Data,3,false)

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________