Greetings,
Given the below scenario, I want to make Field _4 , in Table_B auto populate, based on Table_A, much like an HLOOKUP or VLOOKUP in Excel.
For example:
If I the next entry in Field_3 is d, I want the table to look in Field_1 for d and autofill with the corresponding color red in Field_2.
Again I DON'T want to have to choose anything for Field_4. I want it automatically filled in. ANY HELP IS GREATLY APPRECIATED!
Table_A
________________________________
Field_1 | Field_2
________________________________
|
a | green
b | brown
c | gray
d | red
e | blue
f | black
g | yellow
h | pink
i | orange
Table_B
________________________________
Field_3 | Field_4
________________________________
i | orange
g | yellow
c | gray
c | gray
i | orange
a | green
g | yellow
c | gray
a | green