VBA for VlookUp copy and paste

[rxpotlu]

Team - Could you please help me with below?
i am looking for vba - to take cell c3 from sheet2 search for column a in sheet1 if a match is found then copy the value from b column which is next to the match cell in a to a specific cell in sheet2.

 

[Joe4]

Welcome to the Board!

You are looking up the value from cell C3 on sheet 2, but where are you placing this value you find on sheet 2?

 

[rxpotlu]

a	x	d1	search a in column A, if a match then copy whats in column b (in this case x) to a specific column in sheet 2
b	y	e1
c	z	w1
d	x2	r1

 

[rxpotlu]

above is the example. sorry for the confusion

 

[Joe4]

But what is the "specific column"?
If you want us to help you come up with the VBA code you need, we need details, not generalities.

So, look up the value from C3 and paste the result of the lookup to where? Cell D3 maybe?
And are we just doing this one cell, or a whole range of cells?
If a range, what exactly is that range?

 

[rxpotlu]

lemme retry this.

1	A	B	C	D	E	F	G	H
2	Currency	bank	bank name				currency	aud
3	aud	abc	abc 123				bank
4	cad	xyz	xyz 567				bank name
5	usd	rrr	rrr 444

if h2 is in column a then copy value in b and c to h3 and h4. so for example. h2 here is aud, so abc should be pasted in h3 and abc 123 in h4.

 

[Joe4]

Assuming that G and H are on Sheet2 and columns A, B, and C are on Sheet1 (like you said in your original question), try this code:

Sub MyMacro()

'   Populate lookup formulas
    Range("H3").FormulaR1C1 = "=VLOOKUP(R[-1]C,Sheet1!C[-7]:C[-6],2,0)"
    Range("H4").FormulaR1C1 = "=VLOOKUP(R[-2]C,Sheet1!C[-7]:C[-5],3,0)"
    
'   Convert to hard-coded values
    Range("H3:H4").Value = Range("H3:H4").Value
    
End Sub