data classification question

[excelconfusing]

Hi my name is mirna, I am new in this forum, I am seeking for help with this:

I have a list of clients, each of them has a clasification,

ClientX - Fecuent Client
ClientW - Prospect Client
Clienty - Esporadic Client

I want to write the name of the client and automatically appears the type of client in the next cell

Is that possible?

Thanks!

[shg]

Welcome to the forum, mirna.

Please take a few minutes to read teh forum rules, and then amend your thread title accordingly.

Thanks.

[excelconfusing]

I changed the title, hope somebody could help, Thanks!

[JBeaucaire]

You can use VLOOKUP or LOOKUP or INDEX/MATCH to do these kind of things. Press F1 in Excel to read up on these functions.

INDEX/MATCH is my personal favorite because it suffers from none of the limitations you find with LOOKUP() and VLOOKUP(). Here's a sample sheet showing how entering codes on Sheet1 can grab info from SHeet2 and display it automatically.

[excelconfusing]

Wow! you are my hero!!!

I opened the file, I just need to understand the formula and apply it to my document.

That is exactly what I wanted to do!!!! And no body of my friends or at my job could help

Thanks a lot!!!

[excelconfusing]

I applied it to my archive and it worked!!! how exciting!!

Now, taking your same example, If I write a different number than:

211
149
139
132

For example 536, What if I want to appear "not recognized"

How can I do it?


Thanks in advance!

[JBeaucaire]

You have to check the MATCH() formula to see if it's going to work, if not give your "not recognized" response, if so, then do the whole formula:

=IF(A2="", "", IF(ISERROR(MATCH(A2,Codes!$A:$A,0)), "Not recognized", INDEX(Codes!B:B, MATCH(A2,Codes!$A:$A,0))))

[excelconfusing]

Thanks again JBeaucaire you have made my life easier!

Thanks for sharing your knowledge guru!

[JBeaucaire]

My pleasure, glad I could help.

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

[excelconfusing]

Thanks I just put the PREFIX SOLVED

It worked perfectly as you told me

Just wonderingt if this the only way to do it? or there is an easier formula?
I have like 15 countries who are High Estrategy, and another bunch who are Low Estrategy. (this is for another excel archive)

Thanks!

[JBeaucaire]

If you have followup questions relating to this same thread, post them here along with a sample workbook showing the problem and desired solution.

If it's entirely new, a new thread would be best with a link to this thread if you find anything that's gone on here to be actually helpful moving forward with the new issue. It's usually not needed.

[excelconfusing]

Thanks, this is related to the same topic...

Formulas were working perfectly until I noticed other formulas related to the result were showing #N/a

This is not working:

=SUMPRODUCT((TIPO_DE_E_AGO="EA")*(TIPO_DE_CLIENTE_AGO="PROSPECTO-NUEVO"))

But this one does work

=COUNTIF(TIPO_DE_CLIENTE_AGO, "PROSPECTO-NUEVO")

"PROSPECTO NUEVO" is one of the results for the formula you gave me before:

=IF(F215="","", INDEX( CLIENTES!D:D, MATCH(F215,CLIENTES!$B:$B,0)))

Please check attachment, AGO sheet, Thank you very much!!!!!

[excelconfusing]

Upload Errors
PRICING REPORT 2009.xls:
Upload of file failed.

=( =(

[excelconfusing]

tRYING AGAIN
8
I can not make it any smaller than 2434kb!! I can not understand why!! =( It has very few data!

[JBeaucaire]

Just zip the file, that should do it.

[excelconfusing]

tHANKS!

i Just noticed that if I erase some rows it works, but why this happens?

[excelconfusing]

It worked! It worked! Thanks!
I just filled out the blank cells and it worked!! =)