MOREFUNC

  • Thread starter Thread starter nemadrias
  • Start date Start date
N

nemadrias

Hi - I downloaded and am trying to use the morefunc addin to make
VLOOKUP work across multiple sheets in a workbook. Can anyone tell me
what's wrong with my syntax?



=VLOOKUP("ORIENTAL FOOD",THREED(Asian:Results!A7:A506),2,0)

The search term is "ORIENTAL FOOD", the two sheets are 'Asian' and
'Results', the range is A7:A506 in Asian, and I want to return data
from the second column exactly matching my search string.

Yet i get a #REF. ANYONE HELP ME???
Thanks in advance.
Steve
 
Ok - that worked for me - can I do it so that it brings back all
instances of whatever I'm searching for (there are multiple entries in
that column). Thanks alot!
Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating copy of sheet into new file results in #REF errors 1
Sheets Skip Macro 2
Indirect.ext 3
Using wild card characters in Find & Replace 6
How can I use a cell value to select a sheet tab? 6
Wits end wrt automatic linking 3
Database price updating 3
Using SUM & VLOOKUP together?? 1

Back
Top