Look up in a different sheet in macro

[Afsheen]

I want to look up in diffrent sheet.
The current formula is as below

Please Login or Register  to view this content.

How do I apply this in macro/VBA

macro needs to be applied in Sheet3.Cells(7,1)

Lookup value is in Sheet1.Cells(Y,25)

I have tried

Please Login or Register  to view this content.

but not successful.

[vba_php]

you said:

but not successful

so what happened? got an error? got #Name? in the cell? #NUM! in the cell?

i assume you've read this?

https://docs.microsoft.com/en-us/off...nction.vlookup

[rorya]

This:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

[davesexcel]

If you are working with cells(r,c) you don't combine with cell references but row and column references.

Please Login or Register  to view this content.

would not work,
Since your range is wrong the code will error.

Please Login or Register  to view this content.

This is assuming Y is an actual integer.
If it is supposed to be Column X like in your original formula, then it should be range("X3") or cells(3,"X") or cells(3,24)