Concatenate + Vlookup change to one function or Macros

Hello

I need a function or macro to match Original columns with System columns.
I made a function for example for Result - Est ID on column K =IF(AND(A3=D3,B3=F3,C3=H3),E3,"NULL") but it check just by one row number 3.
But I need to check for example cell A3 with all column D AND cell B3 with all column F AND cell C3 with all column H.
IF for example cells A3, B3, C3 are match with any of D,F,H THEN to use IDs from columns E,G,I and put them to K3,L3,M3.

It's important to match 3 columns in one and keep in result order of 'Original' columns

Before I used for example =CONCATENATE(A3:A7,B3:B7,C3:C7), and for 'System' columns and after that used results from CONCATENATE to use for future VLOOKUP for Results Est ID, Floor ID and Room ID

Is it possible to do it in once?

Example Excel document in attach

H iKnotka,


See the attached file where I used below formula, entered with key combination ctrl shift enter:-

Formula:

Please Login or Register  to view this content.

Compare Macro(1).xlsx

Regards,
DILIPandey
<click on below * if this helps>

You can try below for vlookup:-

Formula:

Please Login or Register  to view this content.

entered with ctrl shift enter key combination
but will give you first set of result - repeated in all 3 places

Regards,
DILIPandey
<click on below * if this helps>

you are welcome Knotka...

Cheers


Please mark this thread as [SOLVED].. thanks.


Regards,
DILIPandey
<click on below * if this helps>