First post to the forums.
I recently built a "database" per say using Excel but I have decided to use Access instead. I have some very long Vlookup formula's in the Excel document that I still need to use in the Access database.
Here's what I'm working with:
I have part #'s that can be input in many different formats in column A but column B does a Vlookup and translates column A to a updated and correctly formatted part #. Then column C refers to column B and returns a series for that part #.
A part # could be entered as A1-AA1-1111-A1, AA1-1111, AA1-1111-A1 or 12-345678. Of course the A's and #'s are just place holders. That's why these VLookups are so long, because they have to go through any of those possibilities to find the correct corresponding part number. In the end (column B) the part number should be in the 12-345678 format, if the reference table has a corresponding part #.
I attached screenshots of the Vlookup's that are currently being used. The longer one is what would be in column B and the shorter would be in Column C.
Is there a easy way to transfer these to a format for Access? I'm using a Table in Access, similar to Excel, so if a user inputs a part number in one column, the next column over needs to display the correct part #/format.
Thanks in advanced!