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

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

lookup table ? what is it? How to create a table ?

Capuchin

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

Thanks a lot it's working very well

Thanks again

ScottGem

Cap is correct. You need the VLookup (or HLookup) function. Check Excel help for how they work.