Vlookup Formula with variable

[rizmomin]

Hello:

I need a varaible to apply in Vlookup function.

Assume I have J3 = 4

I have formula in cell E3 = VLookup(C5,Data,XX,0)
Here i need XX to be the value of J3 so formula needs to be like:

=Vlookup(C5,Data,4,0)

Please let me know if any questions.

Riz

[Pete_UK]

Try this:

= VLookup(C5,Data,J3,0)

although you might want to trap errors if there is no exact match, like this:

=IFERROR(VLookup(C5,Data,J3,0),"")

Hope this helps.

Pete

[rizmomin]

Hello Pete:

Seems to works, will do futher testing and let u know if any issues.
Thanks a lot

Riz