How to do Vlookup of 2 argument

shahid5788

Banned
Joined
Jun 2, 2017
Messages
5
Reaction score
0
Points
0
Hi,

I am trying to get a Vlookup that has 2 arguments in the formula where it looks one "Location" and "Client ID" from Sheet 2.


Vlookup(Location&Client ID,In Sheet 2, Lookup State,False)


See attachment
 

Attachments

  • Vlookup with 2 argument.xlsx
    11.1 KB · Views: 9
Thank you for help, I was wondering if there anyway to incorporate a VBA code with the above formula?
 
Thank you for help, I was wondering if there anyway to incorporate a VBA code with the above formula?
VBA has its own functions and processes which are more extensive than Excel, but at the same time you can invoke any of the Excel formulae within VBA, and assign the result to a cell or variable.
 
Last edited:
cross posted without links:
https://www.excelforum.com/excel-general/1189557-how-to-do-vlookup-of-2-argument.html
http://windowssecrets.com/forums/showthread.php/180865-How-to-do-Vlookup-of-2-argument
https://www.mrexcel.com/forum/excel-questions/1010118-how-do-vlookup-2-argument.html

shahid5788, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184
 
Back
Top