Formula Question

[4seas]

I am setting up 3 different "fill in" worksheets for our sales department. I
have all the pricing and informaiton on several sheets according to brand.
What I would like find out is if there is some way I can have certain areas
of the fill in sheets automatically filled in without the sales person having
to go look up the information. Iv'e been going through the "if" formula, but
can't get it to work.
Thanks for any help

 

[Niek Otten]

Look at the VLOOKUP() function.

There's a tutorial here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am setting up 3 different "fill in" worksheets for our sales department. I
| have all the pricing and informaiton on several sheets according to brand.
| What I would like find out is if there is some way I can have certain areas
| of the fill in sheets automatically filled in without the sales person having
| to go look up the information. Iv'e been going through the "if" formula, but
| can't get it to work.
| Thanks for any help