Reference formula from another cell not the value

[mense23]

I am creating an invoice workbook for someone. In anothe
workbook(Material List.xls) I have a description on the item in colum
B and the price of that item in column D. In the invoice spreadsheet
have them select the description field by selecting ='[Materia
List.xls]SPT MSR 1650'!$B$7. I would like to fill in the price from th
Material List workbook automatically by reference the formula the use
enters

 

[Frank Kabel]

Hi
if the user only enter the reference like the following in A1
'[MaterialList.xls]SPT MSR 1650'!$B$7

you may use
=INDIRECT(A1)
note: works only if the other workbook is open!

 

[mense23]

If I remove the = sign the value in the cell just becomes a text value.
Am I missing something.

 

[Frank Kabel]

Hi
i think I did not understand your problem correctly. Could you give an
example with some example data for what you're trying to achieve. Maybe
VLOOKUP is the function you're looking for

 

[mense23]

OK.

I have the invoice spreadsheet in Column C the user will select
the cell from the Material Workbook to match the Description of th
item he wants (notice on the picture there is multiple sheets on th
Material workbook.) Once the user selects the Description I am lookin
to have the price completed in Addieville's Column D.
Price Per Unit. I have done VLookup before, but everything was on th
same Sheet. I have multiple sheet in the Material Workbook to make i
easier on the end-user

Attachment filename: excel.jpg
Download attachment: http://www.excelforum.com/attachment.php?postid=51243

 

[Frank Kabel]

Hi
maybe something like
=VLOOKUP(C1,'othersheet'!A1:B100,2,0)

 

[gxtkahyr]

http://www.ardice.com/Regional/North_America/United_States/Illinois/Localities/A/Addieville/