Nov 03 2020 01:44 PM
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:
Nov 03 2020 02:27 PM
VLOOKUP returns first found value, not multiple ones. If you are on Excel 365 that could be like