Vlookup using a statment

[FSalgueiro]

Can someone help with the formula below? I am trying to use a vlookup to return a value
=vlookup((D2&F2&G2),'Sheet2'!' ((M2&T2&AA2)),5,false)

[XOR LX]

Hi,

I'm a little curious as to what your table_array is here: 'Sheet2'!' ((M2&T2&AA2)).

You are aware that this parameter is the range of cells you wish to consider, with the leftmost column being that in which you are searching for your lookup_value?

Can you explain in words exactly what it is you are trying to achieve? Or, even better, attach a sample workbook?

Regards

[FDibbins]

It's often (for me anyway) to create a helper column in your data when trying something like this. Then use index/match to find what you want

[FSalgueiro]

Please see sample in attached

[FDibbins]

You didnt provide much in the way of sample data, so this is untested...
=-INDEX(Sheet2!$O$1:$O$1,,MATCH(Sheet1!A2&Sheet1!D2&Sheet1!G2,Sheet2!D1&Sheet2!J1&Sheet2!M1,0))
entered as an ARRAY formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.