Excel Tips & Tricks

The Vlookup function requires a unique field to find. As you can see from the example we have two rows for each item, one for the small size and one for the large size. So we first need to use the concatenate function to create a unique field to search on before we use the Vlookup function. ................
................

In order to avoid copyright disputes, this page is only a partial summary.