• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

vba- how to use vlookup(concatenate) function.

bevg1971

New Member
I don't know how to use the vlookup(concatenate) function using bva.
I need to use the values in column b and column c.
then I need to go to the list in i2:j3 (or this list can be located in sheet2) to match the values which have been concatenated.
Then i need to copy and paste the result in column E.
for example,
b2 and d2 will create the code US55 OK, then i need to go over to the list in I1:J3 to match the value, which is in cell i2, i need to copy the result which in cell j2 ( 2 ).
I need to copy that result and paste it in E2.

upload_2015-1-23_12-34-59-png.15082


any help will be greatly appreciated. thank you.
 
Bevg1971

Can you please post files instead of pics in future

Have you tried: =Vlookup(B2&" "&D2,$I$2:$J$3,2,False)

why include the header row ?
 
Hi Hui, thank you for the information... the header is included in case a report/pivot needs to be created by the end user. I have attached the excel file. i have no idea how to write the code to do the vlookup... do you have any existing make that i can edit to make it work with my data?
 

Attachments

  • file to test vlooup.xlsm
    13.7 KB · Views: 8
Back
Top