| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOREFUNC
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MOREFUNC
Assuming that you want to return the corresponding value in Column B
(the second column), try... =VLOOKUP("ORIENTAL FOOD",THREED(Asian:Results!A7:B506),2,0) Hope this helps! In article .com, "nemadrias" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
MOREFUNC
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 Domenic wrote: Assuming that you want to return the corresponding value in Column B (the second column), try... =VLOOKUP("ORIENTAL FOOD",THREED(Asian:Results!A7:B506),2,0) Hope this helps! In article .com, "nemadrias" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternatives to GET.CELL and VB? | Excel Worksheet Functions | |||
| Using Morefunc - Indirect.Ext when Offline | Excel Worksheet Functions | |||
| Morefunc | Excel Discussion (Misc queries) | |||
| Need a short cut for this... | Excel Worksheet Functions | |||
| Morefunc | Excel Discussion (Misc queries) | |||
Linear Mode
