Vlookup in Macro

[shiser]

Hi,

Just wanted to know whether it was possible to have a vlookup in my current macro. Heres a short version of it

Please Login or Register  to view this content.

So essentially, I want to replace sTab with a vlookup dependent on what sName is selected which would be a drop down.

Please Login or Register  to view this content.

So something along the lines of:

Please Login or Register  to view this content.

This obviously isn't correct but its a general idea of what i'm looking for

Thanks

[6StringJazzer]

Here is the direct translation but I'm not clear on what you're trying to accomplish. I don't know how I4 and D4:G16 fit into the picture.

Please Login or Register  to view this content.

[shiser]

Didn't work

So basically the vlookup is dependent on what is selected = "sname" which is located in cell "I4" of sheet 35.

In sheet 35, it'll lookup up I4 in the range D4:G16 picking the result of what appears in the second column

[shiser]

Nevermind! I've found a work around

[6StringJazzer]

If you're happy, I'm happy, but I am curious about what "didn't work" means. If those ranges are in a different sheet than the active sheet, then you will have to qualify the references explicitly. Also interested in your workaround.

[shiser]

One of the reasons why I wanted the vlookup in the macro was so it'll automatically calculate without me having to press F9. Instead however, I put the vlookup in excel, hid the columns and inserted calculate.sheet into my macro. Seems an easy workaround for me.