Forum Discussion
Excel formula
Hi, I need a way to look for specific data within an Excel table. If the data from an Excel cell matches the information inside the table, then in another Excel cell, the value related to that ce...
Hi,
This what VLOOKUP function is good at!
=VLOOKUP(A2,$E$2:$F$6,2,0)
To learn more about VLOOKUP, check out these links:
https://support.office.com/en-us/article/vlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1
https://www.youtube.com/watch?v=GZX2iXfqALs
Hope that helps
Hello,
You would want to use the VLOOKUP() function for this. Read more here:
https://www.laptopmag.com/articles/excel-2013-vlookup
You would want to use the VLOOKUP() function for this. Read more here:
https://www.laptopmag.com/articles/excel-2013-vlookup