Vlookup for multiple values

Microsoft

Hello all, first time posting on the Excel tech community - and I've found some great posts on Vlookup for multiple values from the same reference data.  What I'm doing is looking at a list of Virtual Machines and trying to populate the right of each VM row with Disk size info from another chart. This is the best way to explain: 

James_Farq_0-1604438826608.png

 

1 Reply

@James_Farq 

VLOOKUP returns first found value, not multiple ones. If you are on Excel 365 that could be like

image.png