Excel challenge

[conphara]

Hi


I have a cell value (X) in one sheet (sheet X). That value (X) is in a matrix in another sheet (sheet Y) and is found in many rows (duplicates) but I am interested in the values from those rows. Normally I would use a vlookup but the challenge is this:

Every row in the matrix has a week number and several rows have the same week number. I have a certain week number in sheet X that has to match with the week number from the row that a vlookup would find.

Sheet X:
Value X
Week number 31

Sheet Y:
row 1: Week number 31. Value X. Value Y. Value Z.
row 2: Week number 32. Value X. Value Y. Value Z.

I want to return value Y is Value X is the same but only if the week numbers match.

 

[conphara]

Thank you very much! Now it works beautifully.

PS. Why should there even be a difference between "," and ";" since ";" makes more sense being a seperator?

 

[Aladin Akyurek]

Thank you very much! Now it works beautifully.

Great. Thansks for providing feedback.

PS. Why should there even be a difference between "," and ";" since ";" makes more sense being a seperator?

Different conventions...