Use VLookup in VBA

[jaidubb]

Can I use vlookup to search values and ranges and two sheets and return results to a blank sheet (Sheet3)? For example, sheet2 has a value in B2. Sheet1 has the same value in E2, but I want to return the value in A2 to sheet3. I want to do this is vba. If possible, any suggestions to get me started? Thanks

 

[alansidman]

This should get you started http://www.cpearson.com/excel/CallingWorksheetFunctionsInVBA.aspx

 

[DanteAmor]

You can give examples with data of what you have on each sheet, what you want to look for, where you want to search and what result you expect.

 

[offthelip]

You could have a look at this thread which shows you how to do it in VBA without using Vlookup but in a more flexible programatic way:
https://www.mrexcel.com/forum/excel-questions/1043185-vlookup-vba-alternative.html