lookup in vba

[gmatriix]

Hello,

Could someone help me with this code? Just trying to do a vlookup that will reference the exception sheet whether Im on a new workbook or not. I just want to put in zlookup and it will look up B2, on Exception Report Test.xls]TABLE'!$A$2:$D$126. Is this possible??????

Function Zlookup() As Long

Dim zlook As Long

zlook = Application.VLookup(B2, Range("'[Exception Report Test.xls]TABLE'!$A$2:$D$126"), 4, False)

End Function

 

[ajetrumpet]

of course it's possible sir. how about uploading the book?

 

[Brianwarnock]

Adam, how is that supposed to be helpfull?

Brian

 

[ajetrumpet]

Adam, how is that supposed to be helpfull?

Brian

First of all Brian, I've known this person for a long time, and i know he's not just getting freebies here. I don't really know what he's talking about, and therefore, having a visual will help me get a strangle hold on this, and wrap it around the head...(so to speak).

Any other questions wise one?

 

[gmatriix]

What up buddy...

I am going to try my hand at UDFs to see if that will work. If I run into some problems I will let you know...

Thanks pz