=IF for 19 lists of 13 cells each one with data

[Immortal2014]

Hello guys.19 lists, every list have 13 cells with numbers. in M7 cell if i write a number from a random list i want to take in cell M8 the title of number's list.
Thanks in advance.

[Jakobshavn]

Use:

=IF(ISERROR(MATCH(A1,K:K,0)),"",K1)

[Immortal2014]

Thank you very muchfor your help!

[Immortal2014]

Hmm maybe i have something wrong?

Please Login or Register  to view this content.

[jason.b75]

Ok that's a bit better, the reason behind my suggestion though was that there is no =IF in the solution, so really speaking your title is your anticipated solution rather than your question.

Please Login or Register  to view this content.

This formula must be confirmed as an array by holding down Shift and Ctrl and pressing Enter. If you just press Enter then it will return #N/A!

[Immortal2014]

Yes you're right i struggle it. I make another one try with title, i dont know how to explain better, sory. If you understand what i need and you want to help me ok, if not, dont worry.
Thanks.

[jason.b75]

Please do not start another thread, that would be another breach of the rules.

I've edited my last post to show you the formula that you need.

[Immortal2014]

Thanks for your help and sory about that, when insert the code the result is #ΤΙΜΗ! or in english #VALUE! Any other advice?

[jason.b75]

Sorry, that was my fault, I've just edited my earlier post again.

Select the cell with the formula, then press the f2 key. Now hold down Shift and Ctrl together, and press Enter while you're holding them.

[Immortal2014]

My friend sory but something goes wrong or something im doing wrong. When im pressing F2 and after Shift+Ctrl together and press enter appears a window to update the values for ΛΙΣΤΑ, i closing this window and then #N/A!

[jason.b75]

That sounds to me like excel doesn't recognise ΛΙΣΤΑ as the name of your sheet.

Can you upload the real sheet, or does it contain sensitive / confidential data?

[grimes0332]

For info, this problem also posted. www.ozgrid.com/forum/showthread.php?t=196921

[Immortal2014]

ok just a moment please

[Immortal2014]

Ahh just now i open the workbook to change some data and i test it again and works fine. jason.b75 thank you very muchfor your help is precious for me.

grimes0332 your late. Even if im fault for this second thread in ozgrid i think that the moderators dont need your help for this. You are here for moderation or for ask/give help?
Always friendly

[grimes0332]

No, I'm not here for moderation but when I am here I follow the rules.

Perhaps I should just go away,. Haven't been on this board long, but this is my last post you'll be happy to hear.

[jason.b75]

Strange things do happen sometimes. Good to hear it is working now.

For future reference, if you do post the same question on more than one forum, please provide the links to the other forums when you start your thread. It can save us time if we can look there to see what has already been tried. If you make a habit of not providing links to cross posts you might find that people become reluctant to help you.

[Immortal2014]

for grimes0332

Ok your first 6 words covered me. I dont even care for all other you doing here. If my double threads doesnt follow the rules i accept only criticism from moderators or persons who moderate this forum.

[Immortal2014]

Strange things do happen sometimes. Good to hear it is working now.

For future reference, if you do post the same question on more than one forum, please provide the links to the other forums when you start your thread. It can save us time if we can look there to see what has already been tried. If you make a habit of not providing links to cross posts you might find that people become reluctant to help you.

Yes i cant say anything about this. You'll right jason.b75 for the the links, i wasnt thinking it. Thanks again for your help man.

[jason.b75]

Grimes and Immortal, please try and be civilised.

If you can't manage that, try spending time on Jerry Springer's show.

Grimes was not wrong to raise the point of your cross post, something which Jacobshavn should have done instead of just providing you with an answer on both forums.

edit:-

I'm not a moderator, and prefer to stay away from forum politics, but like many other experienced forum users, I will try to point new members in the right direction.

[Immortal2014]

jason the workbookis here http://www.excelforum.com/excel-gene...-in-cells.html if you want to see it because i was uploaded to you before, perhaps it have some differences with ΛΙΣΤΑ maybe is here like ΟΧΗΜΑΤΑ but i have another things inside who i need.

[jason.b75]

I was only asking for the copy because of the problems you were having back in post #10, it looks like you have it working now.

If you have any more questions relating to this workbook then it would be a good idea to upload a new copy of the workbook that includes any changes you have made since.

[JBeaucaire]

All help given on this forum, even unsolicited member to member forum advice regarding rules, is acceptable when civil and it is expected that questioners will accept this advice as well as on-topic Excel advice equally.

Thanks for playing nice, all.

[Immortal2014]

All help given on this forum, even unsolicited member to member forum advice regarding rules, is acceptable when civil and it is expected that questioners will accept this advice as well as on-topic Excel advice equally.

Thanks for playing nice, all.

I am available full to accept any criticism for the mistakes that I do here, by any administrator, moderator who is responsible for the Forum. If there was a case to be criticized by a member, would accept as follows: My friend, you have read the rules of the forums? You've made a mistake. Please, if you want to have assistance from other members, fix it.
the best that could make someone a member of the forum is to report the matter appropriately.
I hope to understand me.

Friendly!

[JBeaucaire]

I'll stand by my original post #22. Any member who politely points out rule corrections is doing you a favor. A simple "thank you" and back to the topic at hand will always serve best.

Cheers.