Formula or Function

[Millie]

I am working on a worksheet that has mulitiple tabs and on one of th
tabs contsists of a pricelist that I would like the information to com
up on the other tabs. For example: If I place a model number in on
column and I want the price to automatically come out onto the nex
column automatically. Based on my information from the pricelist, wit
the pricelist hidden. Please help

 

[Norman Harker]

Hi Millie!

Select the pricelist cells range and name it in the name box to the
left of the formula bar.

Then you can use the formula:

=VLOOKUP(A1,PriceList,2,FALSE)

A1 is the cell looked up
Pricelist is the range containing the lookup table
2 is the column looked up
FALSE requires an exact match.

Now you can hide the sheet with the PriceList
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Millie]

It is still not working..........see this is for a small painting
business and I have this workbook that consist of 10 tabs with employee
names on each of the tabs and the last tab being the pricelist with all
the information that I need for the different worksheets I have in this
one workbook. This is what I am looking for:

Model # Price
1215 $469.00

I placed the model number manually, but the price came out
automatically based on the pricelist on the last tab and it can't be in
order. I tried the VLOOKUP function and it is not working.

Please Help! I know that this is possible in exel, I just need that
jump start.....I would really appreciate it.

 

[Frank Kabel]

Hi

VLOOKUP should work just fine. Maybe you can post that you have
entered. Together with cell examples
Frank

 

[Millie]

would I start the lookup function on the pricelist tab or any of th
other tabs.....I think that is my proble

 

[Frank Kabel]

You have to enter the VLOOKUP function on the other tabs
Frank

 

[Millie]

I really appreciate your help and I hope that I dont sound clueless, bu
the other tabs are blank what I've been doing is click on A1 inser
VLOOKUP Function, then click on the price list tab and shade what
want it to look up, which is about 6 columns and 35 rows, then clic
back to the tab, press okay, then an error comes out.

I know that I am still doing something wrong and it is probably ver
simple, but I do apprciate your help with thi

 

[Norman Harker]

Hi Millie!

You sound a bit lost still. Send a copy by email only (*not* to
newsgroup) and I'll take a look.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Millie]

Hello,

I have been out of town and just emailed you the worksheet for your
help as you suggested..........I appreciate your help!

 

[Norman Harker]

Hi Millie!

Have done and returned. All that was really needed was to use VLOOKUP
on a table in another sheet. Additional work on hiding the sheet,
hiding display of the formula and protecting workbook and sheets.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.