0

Simple Dataset

See above image but I'm basically trying to get Susan's vegetable preference from the 2nd smaller "table" to the right column in the bigger table without doing it manually. I'm working with a huge dataset, there's no way we could do it manually. What approach could I try?

This is for work, except the names are roles, and the veggies are permissions, just created this as a quick example

halfer
  • 19,824
  • 17
  • 99
  • 186
Nathan Owens
  • 1
  • 1
    https://stackoverflow.com/questions/42492758/vlookup-using-2-columns-to-reference-another – BigBen Sep 12 '22 at 19:36
  • In your example it's all Susan in the small table; therefore a regular VLOOKUP or INDEX/MATCH could work. – P.b Sep 12 '22 at 20:43

1 Answers1

0
INDEX($K$3:$K$5,MATCH($B3,$J$3:$J$5,0))

Enter into G3 and drag down

e_conomics
  • 86
  • 10