multiple criteria search

[brazill23]

Hi All,

Thank you for your help in advance. Im looking to find formula with find X based on:
111 is my part number in different sheet, and looking for formula with find for part 111 order number in column b marked as X

As using vlookup will bring 6 also index match and Im trying to not using 111&order combined.

Any ideas ?

		a	b	c
111		3	6	9
	order		X

<tbody>
</tbody>

Thank You

 

[Special-K99]

Its not lined up, does this mean the data is all lined up or not?

Use this to post some sample spreadsheet data

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[DanteAmor]

I do not understand very well the relationship of your data with the columns.
You could upload an image of your two sheets, put what data you have to perform the search and what data you expect results.
Or
You could upload a copy of your file to a free site such www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. If the workbook contains confidential information, you could replace it with generic data.

 

[brazill23]

		a	b	c
111		3	6	9
	Order		X

<tbody>
</tbody>

Hi Special-K99 its not this is the problem. X is in order row with is one below. And in next sheet i have 111 and I want to find X

 

[Special-K99]

So we must assume the Order line is always one line below the Part Number, yes?
Since that's the only data we have to work on.

Might be better to post with more sample data.

 

[DanteAmor]

		a	b	c
111		3	6	9
	Order		X

<tbody>
</tbody>

Hi Special-K99 its not this is the problem. X is in order row with is one below. And in next sheet i have 111 and I want to find X

Hi, It is not clear, we should literally look for the "x" in column B or in A, B and C

 

[Special-K99]

@brazill23: In order for a formula to work properly it has to work on ALL the data that it is fed. Data may vary. Therefore a pattern needs to be determined within the data.
You cannot determine a pattern with ONE piece of test data.

Please supply more data.