Home > Net >  G-SHEET lookup with multiple criteria horizontal and vertical
G-SHEET lookup with multiple criteria horizontal and vertical

Time:11-08

If you could help me finding a formula that would solve my problem that I've been searching for a solution a few days now

So in my "feuil 1" I have what I'm searching for according to multiple values -the aircraft number -data 1 -cell number -exit date (the value that I'm looking for) like the image below

And in another sheet "LH Synthèse" (the database) I have the aircraft number and data 1 in the same row and the cell number that will give me the exit date according to a specific aircraft and data 1 is the column value my data base What I want to do with this spreadsheet is to have a formula that is going to give me the exit date (present in the sheet "LH Synthèse") according to the values that are in the column A, B, C in the sheet "feuil 1"

The link of the spreadsheet in case my description isn't clear enough enter image description here

  • Related