Forum Discussion

e2liu77's avatar
e2liu77
Icon for Helper I rankHelper I
3 years ago
Solved

How refer the values from mapped tables

Hi,   I have 3 tables: Name A B C   Priority High Medium Low   Name Priority Gap A High 1 B Medium 2 C Low 3 A High 4 B Medium 5 ...
  • e2liu77's avatar
    3 years ago

    C1 and C6 are the location. Value is 1 and 6. Now I figured it out that vlookup will work for this with multiple search options.