Complex Vlookup

[adrdsouza]

In the attached worksheet, I want to lookup values from tab 'KW' to the Tab 'Stock'.
For eg. In columns B,C,D & E I want values against the SKU in Column 'A' but it has to reference the header for columns B,C,D & E with the headers in tab 'KW' to give the value for the respective SKU. What formulas can i use to achieve this?

[Pete_UK]

Put this in B2 of your Stock sheet:

Please Login or Register  to view this content.

then copy across and down.

Hope this helps.

Pete

[Kevin UK]

Hi adrdsouza

Try the INDEX & MATCH as well, in B2 copy across & down.

Please Login or Register  to view this content.