Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ?

Описание к видео Excel Magic Trick 931: VLOOKUP & MATCH: Lookup Values With Special Characters Such As ~ * ?

Download Excel Start File: https://people.highline.edu/mgirvin/Y...

Download workbook: http://people.highline.edu/mgirvin/Ex...
See how to:
1) Create a VLOOKUP formula that can find lookup values that contain special characters such as * ? ~ when the column of lookup value contains text data.
2) Create a MATCH formula that can find lookup values that contain special characters such as * ? ~ when the column of lookup value contains text and number data.

Комментарии

Информация по комментариям в разработке