✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
Regular searches of values are based on a column and using the VLOOKUP function, or in more advanced cases, INDEX and MATCH. But what happens when we need to do a search based on two columns? This is where we have to use a matrix formula to achieve it. In addition we will see how to have dependent validation list.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
11 сен 2024