I run a report every so often for the boss. The data I enter comes from a log system. We get three fields of data, but want to pull a lookup based on those three fields to have it fill in the others (Currently 10 fields, but that could change). The look up data we want to fill in is static, mostly. The goal is to run the report, get the three fields, and ensure that all items are there, or if there are new ones, that we can add them.
Attached is an example. On the data input tab, I would past in the green fields, and yellow would pull from the lookup table tab.
Can I do this with a vlookup? Was not sure as all three fields have to match.
Thanks in advance.
Bookmarks