lookup two values using vba

[yallamanda.b]

HI my dear team,
please help me in lookup two values using vba

please find the attachment.

thanks

 

[Deepak]

Something like!

Const strF As String = "=LOOKUP(,-1/(INDEX(main,,MATCH($A$1,main!$1:$1,0))=$A2)*(INDEX(main,,MATCH($B$1,main!$1:$1,0))=$B2),INDEX(main,,MATCH(C$1,main!$1:$1,0)))"

Sub Query()
With Sheets("fetch").Range("C2:E26")
    .Formula = strF
    .Value = .Value
End With
End Sub

 

[yallamanda.b]

i tested the code but result coming wrong

please guide me..

Thanks

 

[Deepak]

Pls share the expected output in excel.

 

[yallamanda.b]

Hi Deepak,

if addid and trascation id in fetch work sheet is found in main sheet the corresponding addcity,buyer city,subcategeory will come in to fetch sheet in dynamic way.please sea the red color formate in attachment.

Thanks

 

[Deepak]

Working Fine!!

You might not have assigned the named range "main" in the excel. Now named range will also get created in macro itself.

Check with attached!

 

[yallamanda.b]

Thanks Deepak,now it is working fine.