Formula to reference different worksheet cells

[mandicooper]

I am moderately proficient in Excel, but by no means, am I an expert!

I have a workbook with several worksheets in it. On worksheet B I have a list of items in Column A(cells 1-99) and corresponding prices in Column B (cells 1-99).

When working on Worksheet A, if I type an item in cell A1, that is in Worksheet B Column A (any of the cells), I would like for the corresponding price to automatically populate in Worksheet A cell B1. Is this possible?

Thanks in advance for any help!

Mandi

 

[jim may]

In SheetA Cell B1=VLOOKUP(A1,Datatable,2,0)

Where DataTable is a Named Range in SheetB referring to A1:B99