vlookup for table

[CPAC]

Hi I'm trying to match whatever's selected in "details" B1 to find the corresponding sheet sizes in "Material". These values then need to be entered in "Workings" B2 & C2.

Thanks,

[63falcondude]

Try this in B2:

=INDEX(Material!B:B,MATCH(Details!$B1,Material!$A:$A,0))

Drag through C2.

[CPAC]

Perfect thank you...

[63falcondude]

You're welcome. Thanks for the rep!