vlookup

calvarez · Feb 20, 2004

I'm trying to do a vlookup with an array of multiple
sheets but am only getting #VALUE! Any suggestions? Here
is my formula

=VLOOKUP(B2,Boys:Misc!B2:C32,2,FALSE)

Peo Sjoblom · Feb 20, 2004

You can't, Excel's is limited, there is an add-in that can be downloaded
here

http://longre.free.fr/english/

there is an description here

http://www.rhdatasolutions.com/morefunc/

the particular function for you would be THREED

Same forumula returns both 0 & N/A	2	Apr 4, 2013
VLOOKUP & Data Validation	0	Mar 20, 2013
Searching the formula (not the value) for a text string	1	Apr 4, 2014
Help With VLOOKUP	2	Mar 19, 2014
Can I add a formula or function to Vlookup?	1	Apr 8, 2017
Using a vlookup to search multiple criteria for one result?	7	Mar 11, 2013
vlookup formatting problem	1	Feb 1, 2013
Vlookup	1	Nov 5, 2012

vlookup

calvarez

Peo Sjoblom

Ask a Question

Similar Threads