Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split list query for Vlookups
I have a DVD list that is split into three sections to remain small
enough to be O2k3 compatible. To poll this list with vlookup, I can manually convert the table to O2k7, which can handle the data set in a single worksheet. I would like to simply poll the unedited O2k3 compatible sheet. So, instead of a vlookup to a single sheet named range, I would want to: "look at here1" then "look at here2" if not found at here1 then "look at here3" if not found at here2, and stop when it hits the match. Is that an if nesting? My typical string,which uses a common ID field I use is: =VLOOKUP(C4,DVD!A:O,15,FALSE) Where "DVD" is the single worksheet. The compatibility mode sheet would be like three sheets: a-f g-o p-z The info (lookup value) I am looking up from is numeric and whole numbers and a unique set, however. And no, advice toward a database is not what I seek currently. I could name them as named ranges instead of sheets and shorten the formula text a bit I suppose. Like Rng1 Rng2 and Rng3 or the like. Thoughts? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Split list query for Vlookups
This is what it would look like
=IF(ISERROR(VLOOKUP(C4,<Look Here1,<Col1,FALSE)),IF(ISERROR(VLOOKUP(C4,<Look Here2,<Col2,FALSE)),IF(ISERROR(VLOOKUP(C4,<Look Here3,<Col3,FALSE)),"No Match Found",VLOOKUP(C4,<Look Here3,<Col3,FALSE)),VLOOKUP(C4,<Look Here2,<Col2,FALSE)),VLOOKUP(C4,<Look Here1,<Col1,FALSE)) -- If this helps, please click "Yes" <<<<<<<<<<< "CellShocked" wrote: I have a DVD list that is split into three sections to remain small enough to be O2k3 compatible. To poll this list with vlookup, I can manually convert the table to O2k7, which can handle the data set in a single worksheet. I would like to simply poll the unedited O2k3 compatible sheet. So, instead of a vlookup to a single sheet named range, I would want to: "look at here1" then "look at here2" if not found at here1 then "look at here3" if not found at here2, and stop when it hits the match. Is that an if nesting? My typical string,which uses a common ID field I use is: =VLOOKUP(C4,DVD!A:O,15,FALSE) Where "DVD" is the single worksheet. The compatibility mode sheet would be like three sheets: a-f g-o p-z The info (lookup value) I am looking up from is numeric and whole numbers and a unique set, however. And no, advice toward a database is not what I seek currently. I could name them as named ranges instead of sheets and shorten the formula text a bit I suppose. Like Rng1 Rng2 and Rng3 or the like. Thoughts? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Split apart list of part numbers into different columns | Excel Worksheet Functions | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Split list via every other cell. | Excel Discussion (Misc queries) | |||
List Sorted/Split into groups | Excel Worksheet Functions | |||
How do I split a list by every other one in excel? | Excel Discussion (Misc queries) |