Dynamic Update solved

Vishesh's picture

Solution for Question posted on url
http://excelexperts.com/node/1168

I have inserted a column at column A and concatenated the system and discipline. Used Vlookup to get the values. At some places it shows #N/A as there is no exact match of the discipline found.

AttachmentSize
DYNAMIC UPDATES REQ - Solution.xls528.5 KB