one step update

"dk" wrote:

we have a invoice spreadsheet which gets firgures fron a another
spreadsheet
& makes invoice for ex:
invoice column 1= Quantity
invoice column 2= Descriptition
invoice column 3= Price
invoice column 4= Total
Field 1= Name
Field 2= Add
Field 3= City

in the other spreadsheet we have columns with all description of these
column , we like to be able to pick row 36 from other spreadsheet and the
whole info shall be transfered automatically how can we do it?

almost what we want but need different ex; we shall enter in 1 cell row 34
all values only from that row shall in we shall only need to change 1 cell
and all cells shall be changed automatically

"davesexcel" wrote:

>
> Maybe a VLOOKUP formula might be your solution, here's a site that
> expalins it very well
>
> http://www.contextures.com/xlFunctions02.html
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=537541
>
>

according to what we understand vlookup all items details in several cells
which will always pick from those cells but our ex: is we each row has a
different name & charges and we have another sheet which is designed for
invoice so if we will put our invoice customer # 35 (ex: dave) all columns
from row 35 shall be copied in different location in invoice and if we put
lcustomer # 99 all columns from row 99 shall be copied in different
location in invoice

"davesexcel" wrote:

>
> Almost??
>
>
> thats what VLOOKUP does!!
>
> Here's a small example
>
>
> +-------------------------------------------------------------------+
> |Filename: VLOOKUP3.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4710 |
> +-------------------------------------------------------------------+
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=537541
>
>

Please instruct we are new

"dk" wrote:

>
>
> "dk" wrote:
>
> we have a invoice spreadsheet which gets firgures fron a another
> spreadsheet
> & makes invoice for ex:
> invoice column 1= Quantity
> invoice column 2= Descriptition
> invoice column 3= Price
> invoice column 4= Total
> Field 1= Name
> Field 2= Add
> Field 3= City
>
> in the other spreadsheet we have columns with all description of these
> column , we like to be able to pick row 36 from other spreadsheet and the
> whole info shall be transfered automatically how can we do it?

no

"davesexcel" wrote:

>
> were you able to look at the example I posted??
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=537541
>
>

It seems link doesn't work

"dk" wrote:

>
>
> "dk" wrote:
>
> we have a invoice spreadsheet which gets firgures fron a another
> spreadsheet
> & makes invoice for ex:
> invoice column 1= Quantity
> invoice column 2= Descriptition
> invoice column 3= Price
> invoice column 4= Total
> Field 1= Name
> Field 2= Add
> Field 3= City
>
> in the other spreadsheet we have columns with all description of these
> column , we like to be able to pick row 36 from other spreadsheet and the
> whole info shall be transfered automatically how can we do it?

Invalid Attachment specified. If you followed a valid link, please notify the
administrator


"davesexcel" wrote:

>
> I'll give it another try
>
>
> +-------------------------------------------------------------------+
> |Filename: VLOOKUP3.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4717 |
> +-------------------------------------------------------------------+
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=537541
>
>

is there anyway vlookup to refrence to a cell ex: a:25 instead of a value


"davesexcel" wrote:

>
> Well this isn't what I had sent you but here is a site that has VLOOKUP
> examples
>
> http://www.contextures.com/xlFunctions02.html
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=537541
>
>

we read everything we know reference by code or do a search but we don"t find
anyplace how to put ( Enter product code A23 in cell A7 )in a cell # as the
refrence
our product code in cell A7 we want to be a:25 or a:26 or a27) we to put the
exact values as written not wording of a:25 which maybe "tom" or "joe" etc
because we may have 10 times "joe" in column a we want only the joe which is
in cell a:25 etc so we want to input instead of "joe" a:25 and the vlookup is
going to read from a7
"dk" wrote:

>
>
> "dk" wrote:
>
> we have a invoice spreadsheet which gets firgures fron a another
> spreadsheet
> & makes invoice for ex:
> invoice column 1= Quantity
> invoice column 2= Descriptition
> invoice column 3= Price
> invoice column 4= Total
> Field 1= Name
> Field 2= Add
> Field 3= City
>
> in the other spreadsheet we have columns with all description of these
> column , we like to be able to pick row 36 from other spreadsheet and the
> whole info shall be transfered automatically how can we do it?

If you are having a problem with A7 as a product code in a cell
that kind of indicates to me that you might have Transition options
turned on and the A7 is the equivalent of =A7

Make sure you have transition options turned off
Tools, Options, Transition, ..

More information on VLOOKUP at
.. http://www.mvps.org/dmcritchie/excel/vlookup.htm


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dk" <[email protected]> wrote in message news:[email protected]...
> we read everything we know reference by code or do a search but we don"t find
> anyplace how to put ( Enter product code A23 in cell A7 )in a cell # as the
> refrence
> our product code in cell A7 we want to be a:25 or a:26 or a27) we to put the
> exact values as written not wording of a:25 which maybe "tom" or "joe" etc
> because we may have 10 times "joe" in column a we want only the joe which is
> in cell a:25 etc so we want to input instead of "joe" a:25 and the vlookup is
> going to read from a7
> "dk" wrote:
>
> >
> >
> > "dk" wrote:
> >
> > we have a invoice spreadsheet which gets firgures fron a another
> > spreadsheet
> > & makes invoice for ex:
> > invoice column 1= Quantity
> > invoice column 2= Descriptition
> > invoice column 3= Price
> > invoice column 4= Total
> > Field 1= Name
> > Field 2= Add
> > Field 3= City
> >
> > in the other spreadsheet we have columns with all description of these
> > column , we like to be able to pick row 36 from other spreadsheet and the
> > whole info shall be transfered automatically how can we do it?

again, we think there is misunderstanding the vlookup woks fines but we want
to input in the first cell thats created before the vlookup a range or a cell
no. instead of a actual value ex: to prepare an invoice, you can enter a
""""product code" "", and formulas will get the product name or price from
the product table. we want to enter a cell # a25 instead of entering a
product code lets say a25 in the lookup table reads "123" description 'pens"
we don"t want to input "123" we want to put cell a25 and formulas will get
the product description or price from the product table

"David McRitchie" wrote:

> If you are having a problem with A7 as a product code in a cell
> that kind of indicates to me that you might have Transition options
> turned on and the A7 is the equivalent of =A7
>
> Make sure you have transition options turned off
> Tools, Options, Transition, ..
>
> More information on VLOOKUP at
> .. http://www.mvps.org/dmcritchie/excel/vlookup.htm
>
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "dk" <[email protected]> wrote in message news:[email protected]...
> > we read everything we know reference by code or do a search but we don"t find
> > anyplace how to put ( Enter product code A23 in cell A7 )in a cell # as the
> > refrence
> > our product code in cell A7 we want to be a:25 or a:26 or a27) we to put the
> > exact values as written not wording of a:25 which maybe "tom" or "joe" etc
> > because we may have 10 times "joe" in column a we want only the joe which is
> > in cell a:25 etc so we want to input instead of "joe" a:25 and the vlookup is
> > going to read from a7
> > "dk" wrote:
> >
> > >
> > >
> > > "dk" wrote:
> > >
> > > we have a invoice spreadsheet which gets firgures fron a another
> > > spreadsheet
> > > & makes invoice for ex:
> > > invoice column 1= Quantity
> > > invoice column 2= Descriptition
> > > invoice column 3= Price
> > > invoice column 4= Total
> > > Field 1= Name
> > > Field 2= Add
> > > Field 3= City
> > >
> > > in the other spreadsheet we have columns with all description of these
> > > column , we like to be able to pick row 36 from other spreadsheet and the
> > > whole info shall be transfered automatically how can we do it?
>
>
>

Try

=VLOOKUP(INDIRECT(A1),A3:C250,3)

where A1 is the cell where you would put a25


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"dk" <[email protected]> wrote in message
news:[email protected]...
> again, we think there is misunderstanding the vlookup woks fines but we
> want
> to input in the first cell thats created before the vlookup a range or a
> cell
> no. instead of a actual value ex: to prepare an invoice, you can enter a
> """"product code" "", and formulas will get the product name or price from
> the product table. we want to enter a cell # a25 instead of entering a
> product code lets say a25 in the lookup table reads "123" description
> 'pens"
> we don"t want to input "123" we want to put cell a25 and formulas will get
> the product description or price from the product table
>
> "David McRitchie" wrote:
>
>> If you are having a problem with A7 as a product code in a cell
>> that kind of indicates to me that you might have Transition options
>> turned on and the A7 is the equivalent of =A7
>>
>> Make sure you have transition options turned off
>> Tools, Options, Transition, ..
>>
>> More information on VLOOKUP at
>> .. http://www.mvps.org/dmcritchie/excel/vlookup.htm
>>
>>
>> ---
>> HTH,
>> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
>> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
>> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>>
>> "dk" <[email protected]> wrote in message
>> news:[email protected]...
>> > we read everything we know reference by code or do a search but we
>> > don"t find
>> > anyplace how to put ( Enter product code A23 in cell A7 )in a cell # as
>> > the
>> > refrence
>> > our product code in cell A7 we want to be a:25 or a:26 or a27) we to
>> > put the
>> > exact values as written not wording of a:25 which maybe "tom" or "joe"
>> > etc
>> > because we may have 10 times "joe" in column a we want only the joe
>> > which is
>> > in cell a:25 etc so we want to input instead of "joe" a:25 and the
>> > vlookup is
>> > going to read from a7
>> > "dk" wrote:
>> >
>> > >
>> > >
>> > > "dk" wrote:
>> > >
>> > > we have a invoice spreadsheet which gets firgures fron a another
>> > > spreadsheet
>> > > & makes invoice for ex:
>> > > invoice column 1= Quantity
>> > > invoice column 2= Descriptition
>> > > invoice column 3= Price
>> > > invoice column 4= Total
>> > > Field 1= Name
>> > > Field 2= Add
>> > > Field 3= City
>> > >
>> > > in the other spreadsheet we have columns with all description of
>> > > these
>> > > column , we like to be able to pick row 36 from other spreadsheet
>> > > and the
>> > > whole info shall be transfered automatically how can we do it?
>>
>>
>>