Want to do a search on one column then return a value from a column two over

[cmwilbur]

We have a lookup table on my Control WS that looks like attached. I want to write code to do a find on my Object lookup table so that when I pass an ObjSubIn = 8124 then my function will pass back the value of "Q" in column N. How do I do this. This is the code I have coded so far but it is not exactly what I want. Does anyone have any recommendations to cange this code so I get what I want. The client has many different object accounts so I am using this lookup table to identify which column to update in a worksheet instead of hardcoding all my object accounts and columns. Here is the code I have so far. The FIND command works good but I need to return the row and column of where my 8124 was found so I can go two columns over and return the appropriate "Object Column" value.

Please Login or Register  to view this content.

[cmwilbur]

I found a possible solution on the web which seems to do what I want it to do. I am now testing the code.

Please Login or Register  to view this content.

[Whizbang]

Why not use Vlookup?

http://office.microsoft.com/en-us/ex...005209335.aspx

[cmwilbur]

Need to do search within VBA. Looked on the web to code using VLookup logic within VBA but I could not figure the VLookup logic out so I coded it this way. If you have any other ideas I am very willing to hear your suggestions.

[Whizbang]

Please Login or Register  to view this content.