Vlookup excel macro different sheet

This Excel tutorial explains how to use the Excel VLOOKUP function with syntax and examples. The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The tutorial shows how to use VLOOKUP in Excel with many examples, explains how to Vlookup from another sheet and different workbook, search with wildcards, and a lot more. This article begins a series covering VLOOKUP, one of the most useful Excel functions and at the same time one of the most intricate and least understood.Although VBA offers a decent assortment of built-in functions, you might not always find exactly what you need. Fortunately, you can also use most of Excel's worksheet functions in your VBA procedures. The only worksheet functions that you cannot use are those that have an equivalent VBA function ...vlookup in vba On the worksheet I can insert in a cell =VLOOKUP(C5, Hobokee.xls!AcsLow, 2) and it works perfectly, looks up the value in column 2 of the range named AcsLow in the same workbook. But elswhere I want in a macro to lookup the same table and assign the result to a variable BalAmt.=VLOOKUP(The 1st argument is the value to find, so type B4, where the product name is: =VLOOKUP(B4; Type a comma, to end the 1st argument; The 2nd argument is the lookup range - select the product names and prices in the master workbook. Excel automatically adds the other workbook's name, and lookup range name, in the formula.