Try

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

where A1 is the cell where you would put a25


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"dk" wrote in message
...
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" wrote in message
...
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?