Check out some similar questions!

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.