Lookup Issue with attached sheet

[Scarab1963]

Hi I'm trying to add a formula that will look up columns A & D and if they match columns V & W return the values of columns X to AC to columns L to R,
Hope that makes sense?

Can anyone help after a few hours of trying I think it is beyond a self taught excel user

[dilipandey]

Hi Scarab,

Use below formula:-

Please Login or Register  to view this content.

Enter with key combination: ctrl shift enter

Work Sheet.xlsx

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

[Scarab1963]

Thanks DILIPandey

Worked, much appreciated

Regards

Scarab

[dilipandey]

You are welcome Scarab.


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

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