SOLVED

Excel formula

Highlighted
Occasional Contributor

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

Example:

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

Table:

 TABLE WITH THE INFO ARTICLES PRICES Article 3 12 Article 4 3 Article 1 5 Article 2 6 Article 5 7

Result:

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

 ARTICLE PRICE Article 1 5 Article 2 6 Article 3 12 Article 4 3 Article 5 7

3 Replies
Highlighted

Re: Excel formula

Hello,

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

Re: Excel formula

@José Lorenzo Strédel García

Hi,

This what VLOOKUP function is good at!

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