Vllokup formula setup

[morak]

attached worksheet ,i need on on sheet called Productcode in Column B to be ppoulated with the correct page # from the main sheet for each item
Can somebody pleas put in formula and let me learn this for next time

Thank you

[ConneXionLost]

Hi morak,

Strictly speaking, VLOOKUP requires the productcode to be in the left column, so instead, you could use INDEX - MATCH to provide your solution like this:

Please Login or Register  to view this content.

paste this in Sheet2!B1, and autofill down.

Cheers,