PDA

View Full Version : Excel formulas


Ericmagy
Feb 21, 2007, 07:37 AM
Hello

I want to do something like the formulas SUMIF but with a text.

For example two cell must be equal

A b c
Parts number Description qty

12545 bearing XKL 10 units
4587 grease 10ml 20 unit


What I want to is:

In others tab in the same file

When I want to write the number of part that the description appears in the next column??

Thanks

Capuchin
Feb 21, 2007, 07:39 AM
What you want is a lookup table.

Have a read about it in the excel help.

They're a little bit tricky to get to work, but once you do they're very useful :)

Ericmagy
Feb 21, 2007, 07:41 AM
Lookup table ? What is it? How to create a table ?

Capuchin
Feb 21, 2007, 07:44 AM
It looks up the piece of data you specify in a column of a table you specify, and retrieves the piece of information from the same row as that piece of data in a different column.

It's exactly what you want and it's called a "lookup table" and I think you need to use the Excel Lookup formula.

Have a look in the help for it :)

It covers it better than I can.

Ericmagy
Feb 21, 2007, 07:52 AM
Thanks a lot it's working very well

Thanks again

ScottGem
Feb 21, 2007, 07:52 AM
Cap is correct. You need the VLookup (or HLookup) function. Check Excel help for how they work.