I have table column with "Customer Group", "Item", and "Price"
I have another table that pulls (Customer Group & Item) with a vlookup to get price from this table into another one.
I concatenate information in a column, and then look up the concatenated value with this:
=VLOOKUP(B12&E12,I:L,4,0)
Is there a better way?
Thank you much,
Roger!
Bookmarks