SOLVED
Home

Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-815524%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815524%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20way%20to%20look%20for%20specific%20data%20within%20an%20Excel%20table.%20If%20the%20data%20from%20an%20Excel%20cell%20matches%20the%20information%20inside%20the%20table%2C%20then%20in%20another%20Excel%20cell%2C%20the%20value%20related%20to%20that%20cell%20in%20the%20table%20must%20be%20shown.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EDATA%20TO%20FILL%20WITH%20THE%20INFO%20OF%20THE%20TABLE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EARTICLE%3C%2FTD%3E%3CTD%3EPRICE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%201%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%202%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%203%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%204%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%205%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETable%3A%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ETABLE%20WITH%20THE%20INFO%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EARTICLES%3C%2FTD%3E%3CTD%3EPRICES%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%203%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%204%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%201%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%202%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%205%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EResult%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhenever%20an%20article%20appears%20in%20the%20first%20table%2C%20it%20will%20look%20for%20the%20%22PRICE%22%20in%20the%20second%20table%20and%20show%20it%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3EARTICLE%3C%2FTD%3E%3CTD%3EPRICE%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%201%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%202%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%203%3C%2FTD%3E%3CTD%3E12%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%204%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EArticle%205%3C%2FTD%3E%3CTD%3E7%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-815524%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815553%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815553%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20would%20want%20to%20use%20the%20VLOOKUP()%20function%20for%20this.%20Read%20more%20here%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.laptopmag.com%2Farticles%2Fexcel-2013-vlookup%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.laptopmag.com%2Farticles%2Fexcel-2013-vlookup%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-815556%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-815556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F139854%22%20target%3D%22_blank%22%3E%40Jos%C3%A9%20Lorenzo%20Str%C3%A9del%20Garc%C3%ADa%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20what%20VLOOKUP%20function%20is%20good%20at!%3C%2FP%3E%3CPRE%3E%3DVLOOKUP(A2%2C%24E%242%3A%24F%246%2C2%2C0)%3C%2FPRE%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20738px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127863i7F0F4C8B0588066F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22VLOOKUP%20Example.png%22%20title%3D%22VLOOKUP%20Example.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20learn%20more%20about%20VLOOKUP%2C%20check%20out%20these%20links%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fvlookup-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DGZX2iXfqALs%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DGZX2iXfqALs%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816614%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816614%22%20slang%3D%22en-US%22%3E%3CP%3EMany%26nbsp%3Bthanks%20again%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3BI%20know%20get%20what%20I%20was%20doing%20wrong.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
José Lorenzo Strédel García
Occasional Contributor

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 cell in the table must be shown.

 

Example:

 DATA TO FILL WITH THE INFO OF THE TABLE
ARTICLEPRICE
Article 1 
Article 2 
Article 3 
Article 4 
Article 5 

 

Table:

TABLE WITH THE INFO
ARTICLESPRICES
Article 312
Article 43
Article 15
Article 26
Article 57

 

Result:

 

Whenever an article appears in the first table, it will look for the "PRICE" in the second table and show it:

 

ARTICLEPRICE
Article 15
Article 26
Article 312
Article 43
Article 57

 

 

3 Replies
Hello,

You would want to use the VLOOKUP() function for this. Read more here:
https://www.laptopmag.com/articles/excel-2013-vlookup
Solution

@José Lorenzo Strédel García

 

Hi,

 

This what VLOOKUP function is good at!

=VLOOKUP(A2,$E$2:$F$6,2,0)

VLOOKUP Example.png

 

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

Many thanks again @Haytham Amairah I know get what I was doing wrong. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies