search with miltiple criteria on other sheet

[pumuklie]

hi guys

first sorry for my english

i need some help
at1.xls

in first sheet (tr) have a table with 2 parameters: "ids" (A5) and "s" (B1:B8), the second sheet (data) is a data sheet contains 3 datas: "s", "ids", "zat". now on first sheet to the "zat" collumn need to past the value from "zat" collumn on data sheet where "ids" collumn macthing with A5 from first sheet and "s" collum mathing with "s" data from the first sheet.

any idea?

again: sorry for my english

thx

[AB33]

This is how I understand your request.
In sheet tr,column A, you have ids,column B, s
In sheet data,column A, you have ids,column B, s
If both columns match, you want to return column C from sheet data, in to column C of sheet tr.
Issues:
You have merged cells in sheet tr. If I unmerged the cells, you end up with 6a7860 in A5, but B5 is nil.
Unless you want to return based on ids only, how are going to match A5 of sheet tr with sheet data if B5 is nil?
You have
edn 2 6a7860
edn 3 6a7860

In sheet data, but there is no match with sheet tr (6a7860) is fine, but there is no value(Zero) in column B5.
If you could get filled column B of sheet tr, it is easy to match columns and rows, but as it is now, you have one value only in column A5, but the cells in column B are out of line.
I hope you understand the issue.

[FDibbins]

Hi and welcome to the forum

We would love to help you with your question, but 1st, in accordance with forum rule, please rename your thread to something more meaningful, that actually describes your problem.

Because thread titles are used in searching the forum it is vital they be written to accurately describe your thread content or overall objective using ONLY search friendly key words. That is, your title used as search terms would return relevant results.

Also, many members will look at a thread title, and if it is of interest to them, or it falls within their area of expertese, they might only open those threads.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title

[pumuklie]

Thanks for answer.

how I understand your answer problem coused by formating, and a one constant criteria and position of criteria?

if yes, its not a problem. Have a possible to chnage it all.

[AB33]

Pumuklie,
No body can reply to your request until you change the title of the thread as per moderators request. See post#3

[FDibbins]

1st, unmerge the cells C:G, and for future reference, try to avoid using merged cells, they cause more trouble than they are worth.
next, in C2, use this array formula, copied down...
=INDEX(data!$C$1:$C$10,MATCH($B2&$A$5,data!$A$1:$A$10&data!$B$1:$B$10,0),1)
...confirmed by pressing CTRL-SHIFT-ENTER to activate the array. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL-SHIFT-ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

[pumuklie]

I solved problem.

I created a help table, combined these to parameters to one cell in both sheets, and then with wlookup function easy to find necessary data.

thanks for help

[FDibbins]

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[AB33]

Okay!
See attached.
If the match is based on column A only, you do need a code for this task. A simple lookup or match and index will do the job.
However, if the match is based on two columns matching try the attached code.