index&match

Dear all, I am currently trying to return some data from a larger database. I have created a test sheet that is very similar to the real sheet that I am working with, for the sake of privacy and making things easier to understand from an outside perspective. Currently, I have the following...

Hello, Let s say we have this columns and rows 1. A. B. C. D. 2. Name. 01.04.2018. 03.04.2018 2 3. Name. 05.04.2018 10.04.2018 5 This is the Main Page on my worksheet. My questions is, i need to sort all period...

Hi, I need to tell my formula to search for one specific value in two different tabs. I currently wrote this (and it's working): =INDEX(' table (2)'!I2:S727,MATCH('TEST'!P3&'TEST'!Q3,'table (2)'!G2:G727&'table (2)'!H2:H727,0),MATCH('TEST'!R3,'table (2)'!I1:S1,0)) I have two conditions: BLUE...

I posted my original question here: https://stackoverflow.com/questions/30859366/how-to-return-a-header-in-excel-vlookup-and-hlookup but i will ask it again. I am trying to do a multi variable search within a table to return the header. Any help would be awesome.

I'm trying to write an "index & Match" formula that uses the "Morefunc" function, "ARRAY.JOIN" to join nonadjacent ranges, such as: =INDEX((ARRAY.JOIN(C3:C30,G3:G30)),MATCH(N5,ARRAY.JOIN(B3:B30,F3:F30),0)) This formula results in the #VALUE error. Any suggestions? is it not possible to use...