vba- how to use vlookup(concatenate) function.

[bevg1971]

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.

any help will be greatly appreciated. thank you.

 

[Hui]

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 ?

 

[bevg1971]

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?