I have been using the VLOOKUP Command to have a cell lookup my parts database. Thing is the database is too large a file so I want to split it up by first letter of part reference. I now have this problem:
=VLOOKUP(C13,PARTS,2,FALSE) .. I need the name PARTS to be a variable dependant on the part number I enter, the VLOOKUP should search the proper database.. things I have tried are:
* =VLOOKUP(C13,CELL("contents",C13),2,FALSE)
the CELL command refers to the cell where the part number is located. In the Formula Auditing, I traced it and it looks like it will work but .. doesn't
* =VLOOKUP(C13,W13,2,FALSE)
where W13 is the cell containing the name of database I want VLOOKUP to search.. that didn't work either.. Does anyone have any other suggestions? I have started looking in making a function in visual basic but am not very familiar with this stuff... Is there just something that I'm not seeing?? Thanks for any help that anyone may provide.
Tim C.
=VLOOKUP(C13,PARTS,2,FALSE) .. I need the name PARTS to be a variable dependant on the part number I enter, the VLOOKUP should search the proper database.. things I have tried are:
* =VLOOKUP(C13,CELL("contents",C13),2,FALSE)
the CELL command refers to the cell where the part number is located. In the Formula Auditing, I traced it and it looks like it will work but .. doesn't
* =VLOOKUP(C13,W13,2,FALSE)
where W13 is the cell containing the name of database I want VLOOKUP to search.. that didn't work either.. Does anyone have any other suggestions? I have started looking in making a function in visual basic but am not very familiar with this stuff... Is there just something that I'm not seeing?? Thanks for any help that anyone may provide.
Tim C.