Tag Info

Hot answers tagged


There are cleverer ways of doing this but the conventional solution is to add a 'helper' column: Insert a column at the extreme left of PRODUCTS and in A1: =B1&"|"&C1 and copy down to suit. In INVENTORY in C2 insert: =VLOOKUP(A2&"|"&B2,Products!A:D,4,0) and copy down to suit.

Only top voted, non community-wiki answers of a minimum length are eligible