VBA: UDF to perform a 3-parameter Vlookup
(AutomateExcel) Consider the following data table:
The standard Vlookup function within Excel has the following format:
VLOOKUP(''Mark', B6:G12',2,FALSE)
Which will return 'Brown'.
However, what about if we wanted to look up on 2 or more columns e.g the first name,
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 3651]
updated 3651 (Automate Excel), inserted 0, updated 0, at 2012-05-31 00:58:12
