Steps to Populate Multiple Columns using Single Vlookup

Steps to Populate Multiple Columns using Single Vlookup
———————————————————
1) Select Columns or range of cells where we want to
write formula.

2) Type Formula
=VLOOKUP(A3,’Material Master’!A:E,{3,5,2},0)
(AnchorData is name range of Master data)

3) Press Ctrl +Shift+ enter