Recent content by JeremyLek

I tried Index with Match but this formula can only compare with 2 columns. meaning I can search worksheet B's SW ID with Worksheet A 1st column SW ID but not the 2nd SW ID column.

Hi experts, I need some helps on excel on the vlookup. I have 1 workbook with 2 worksheet. In worksheet A, I was given a list of Feature ID with SW IDs meaning 1 Feature ID = many SW IDs Worksheet A eg. Feature ID|SW ID|SW ID|SW ID| Feature_1 |RD_ENT_1|RD_NAVI_23|RD_ENT_2 Feature 2...