We have a table of some products and a lookup table for Budget, City and Shipment type based on category of the product

City is filled using VLOOKUP() function. Shipment Type is filled using INDEX() and MATCH() functions

This time, VLOOKUP() and HLOOKUP() used to create a dynamic column for the third column while INDEX() and MATCH() are used to create a dynamic column for the forth column