PJJDP

Posts: n/a

Thanks Ron, it works perfectly. Funny enough, I tried indirect but it didn't
work. Maybe I missed something somewhere.

Regards

Pieter

"Ron Coderre" wrote:

=Vlookup(a4,INDIRECT(a1&"!"&b2),5,0)

Does that help?

--
Regards,
Ron

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Have Vlookup return a Value of 0 instead of #N/A	Mr Mike	Excel Worksheet Functions	4	May 25th 05 04:51 PM
Array Function with VLOOKUP	CoRrRan	Excel Worksheet Functions	15	April 8th 05 05:54 PM
vlookup data hidden within worksheet		Excel Worksheet Functions	0	January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached?		Excel Worksheet Functions	0	January 25th 05 10:43 AM
VLOOKUP not working	Scott	Excel Worksheet Functions	3	November 12th 04 08:06 PM

All times are GMT +1. The time now is 02:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us