one step update

[dk]

:

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?

 

[davesexcel]

Maybe a VLOOKUP formula might be your solution, here's a site tha
expalins it very well

http://www.contextures.com/xlFunctions02.htm

 

[dk]

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]

Almost??


thats what VLOOKUP does!!

Here's a small example


+-------------------------------------------------------------------+
|Filename: VLOOKUP3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4710 |
+-------------------------------------------------------------------+

 

[dk]

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

 

[dk]

Please instruct we are new

 

[davesexcel]

were you able to look at the example I posted?

 

[dk]

no

 

[dk]

It seems link doesn't work

 

[davesexcel]

I'll give it another try


+-------------------------------------------------------------------+
|Filename: VLOOKUP3.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4717 |
+-------------------------------------------------------------------+

 

[dk]

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

 

[davesexcel]

Well this isn't what I had sent you but here is a site that has VLOOKU
examples

http://www.contextures.com/xlFunctions02.htm

 

[dk]

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

 

[davesexcel]

Maybe you should just print out the pages at the site I forwarded to yo
yesterday and read it, the questions you are asking, tells me yo
haven't

http://www.contextures.com/xlFunctions02.html

And somehow open the simple example I posted, it is a zipped file


also here is a short video

http://www.datapigtechnologies.com/flashfiles/vlookup.html


here is another site that has a vlookup example as well as an invoic
example

http://theofficeexperts.com/downloads.ht

 

[dk]

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

 

[David McRitchie]

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

 

[dk]

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

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

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

 

[Peo Sjoblom]

Try

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

where A1 is the cell where you would put a25


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

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

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

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
:



:

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?