Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup or match function across worksheets (x-post - sorry)
For example I have 15 worksheets in an excel workbook named A through
N. I am looking for the values in worksheet A, Cell A1 (through A250) across worksheets B through N and return the worksheet name that the value exists in. (Worksheet C for example) The first or any exact match is fine. If it doesn't exist #N/A is also fine I can work with the errors returned myself. Is this possible? If the worksheet name is too difficult then any valid result (complete path to cell?) is sufficient. Thank you in advance (Very sorry for the cross / double post) I feel I might have used the incorrect group the first time (Not exactly a .MISC) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match & Vlookup Function | Excel Worksheet Functions | |||
VlookUp or may be Match Function | Excel Worksheet Functions | |||
Vlookup or match function? | Excel Worksheet Functions | |||
vlookup or match function across worksheets ? | Excel Discussion (Misc queries) | |||
vlookup/ match or other function?? | Excel Worksheet Functions |