Excel Wizards?

[TheRealDeal]

Are there any excel wizards in here? If so I need to do a Vlookup using the Indirect function to a file that's name changes every month.

If there anyone that thinks they can help please let me know.

Thanks

[CLTPanther]

http://office.microsoft.com/en-us/excel-help/

[PanthaSan]

Here ya go, it is the best resource I know of for all things MS Office..

Linky

[TheRealDeal]

http://office.microsoft.com/en-us/excel-help/

It's more complex than what help they offer.

Here ya go, it is the best resource I know of for all things MS Office..

Linky

Still not old yet?

Took a shot in the dark and hoped I could get some real answers...off to Mr. Excel.com

[PanthaSan]

Ok ,seroius time. what version of Office? I happen to work with some of the bestest minds when it comes to SS and databases,

Give me an idea of what exactly you need to do and I will pass it on to them..

[TheRealDeal]

Ok ,seroius time. what version of Office? I happen to work with some of the bestest minds when it comes to SS and databases,

Give me an idea of what exactly you need to do and I will pass it on to them..

03

My formula currently looks like this:

=VLOOKUP($G$4,[Oct.xls]ITD!$AS:$BD,MATCH($A16,[Oct.xls]ITD!$AS$1:$BD$1,0),0)

I need to replace the [Oct.xls]ITD!$AS:$BD with a cell reference.

So if I put the path, filename, and sheets in Cell A1 it should read:

=Vlookup($G$4,Indirect(A1),.....

but it's giving me a reference error and I'm not sure why

[PanthaSan]

Ok, I sent out some requests. Is this high priority? We are at half staff cuz it's Friday but if you can wait a bit, I'm sure somebody will have an answer by Tuesday.

The Number Crunchers like this type of distraction....

[PanthaSan]

Here is a quick response....http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

[PanthaSan]

Ok, someone suggested using the Hyperlink feature..............

http://office.microsoft.com/en-us/excel-help/hyperlink-HP005209116.aspx?CTT=5&origin=HP005201149

[TheRealDeal]

I know how to use VLookups very well and the indirect function but when I try to do this and combine them it messes up. I know I'm probably missing a " or ' or ! or something but I can't figure it out.

Thanks for lookin out

[pstall]

mr excel or maybe lifehacker. good luck

[TheRealDeal]

mr excel or maybe lifehacker. good luck

I've asked on Mr. Excel but always get some random ass answer that has nothing to do with my question. I've used it for other questions though and it's good.

Might have to check out lifehacker.

[Ja Rhule]

eh? Just ask someone at work If I need help with excel, I'm going straight to my controller and say " How do you do that?" Then smile pretty and less work for me.