Forum Discussion

José Lorenzo Strédel García's avatar
José Lorenzo Strédel García
Copper Contributor
Aug 21, 2019
Solved

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...
Formulas and Functions
  • Haytham Amairah's avatar
    Haytham Amairah
    Aug 21, 2019

    José Lorenzo Strédel García

     

    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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Aug 21, 2019

José Lorenzo Strédel García

 

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

Resources