Hi;
I have an excel workbook consisting three sheets, and I am trying to make excel fill my lists with the data from the 3rd sheet if all the criterias are met. I somehow managed to do it, but vlookup always picks the first match. My list should not repeat itself, if a matching value picked before from the list, I want excel to choose the second matching option. Then if the second one is picked too, it should select the third one until no matches are left between given cell ranges.
I am uploading my excel file to show my problem.
In the cell "AW5", excel finds a match and copies the data i want. In "AW6" and "AW7", excel finds no matches, ok. ıt finds new matches and so on, but when it comes to cell "AW19", excel finds a match but it is the same first match with the "AW5" cell. what i want to achieve is for the "AW19" cell or cells which have the same situation is to make excel to select the 2nd option or so, and if there's no other match is left; it should leave the cell empty.
can anybody solve my problem or lead me in the way to achieve my goal?
Btw a reminder: the ";" seperator is working like "," in your formulas, caused by local language properties or something like that. when i use comma in a formula, excel gives an error.
Thank You;
Çağrı
Bookmarks