{"id":4651,"date":"2019-09-23T14:12:29","date_gmt":"2019-09-23T14:12:29","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4651"},"modified":"2024-02-19T14:52:39","modified_gmt":"2024-02-19T14:52:39","slug":"vlookup-on-multiple-columns","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/vlookup-on-multiple-columns\/","title":{"rendered":"VLOOKUP on Two (or More) Columns in Excel"},"content":{"rendered":"\n
Normally, when you use VLOOKUP<\/strong>,\nyou are going to check a single condition. VLOOKUP can\u2019t use more than one\ncondition until you modify it a little bit.<\/p>\n\n\n\n In this example, we are going to display a ticket price for a movie. Let\u2019s say we choose The Lion King.<\/p>\n\n\n\nVLOOKUP on a single column<\/h2>\n\n\n\n