Pulling data from database with criteria matching.

Hi Guys

I'm going to have some trouble explaining myself here but I'll try my best.

I have a small database of information that I need to pull some information from into another sheet.

What I want to do is look at the "Voyage Number" and compare that with the source. So from source relevant to OV0010_B11 goes to Source and put it automatically under the source.

Please look at my sample spreadsheet for more understanding.

You may (or should) have access to these formulas, so you can try this - in F8 enter:
=UNIQUE(FILTER($C$2:$C$17,($A$2:$A$17=$F4)*($C$2:$C$17<>"")))
This will try to "Spill down all the values, so delete your results under F8, and they will appear there.
I'm uploading the file for reference.

Thanks for the reply but I dont have some of the functions you have in the example.

I was more looking for something along the lines of Index/Match.

I think they are rolling those functions (Unique, Filter, Sort, etc.) out a little at a time. I am NOT and Insider, just a normal O365 subscriber, and I now have them available to me.

Select in f3 e g3 with dropdown list voyage code and Reason code


F6=IFERROR(INDEX(C$2:C$100,SMALL(IF($B$2:$B$100=$G$3,IF($A$2:$A$100=$F$3,ROW(C$2:C$100)-ROW(C$2)+1)),ROWS($C$2:C2))),"")

control+shift+enter

copy down and across

F5=SUM(G6:G100)

Originally Posted by AliGW

The UNIQUE function is still only available to those on the Office insiders' programme, I believe.

Everyone on the monthly channel now has the dynamic array functions, not sure about the yearly channel.
Also the new Xlookup & XMatch are being rolled out to the monthly channel.
https://twitter.com/jjmcdaid

Thanks! This is exactly what I wanted.

Originally Posted by popipipo

Or you can use a pivot table

This also works, thanks for the tip.