Can VlookUp function use a concatenate formula in the table array area?

Hello everyone

I would be grateful if someone could help me with the following:

I am downloading a specific report which unfortunately cannot add or remove columns (Because of a specific company instruction). What I am trying to do is write a V LOOKUP formula where the table array area will also check a concatenate.

To be more specific, in my example file, what I am trying to do is:
A VLOOK UP function were the lookup value will be the concatenate of columns B & C in Tab 1, while the Table Array Area to check in Tab 2 would be B:E but with concatenate of B and D included.

In other words I am trying to use the same concatenate in table array of the v lookup formula. The col.Index.Num will be any single column of that array.

Many Thanks in advance.

Thank you all. Very helpful solutions.