Excel tutorials

Excel is a great tool to search for and if exists, return those values.

In column A and B we have a list of fruits, and a column of empty prices. In column D and E we have fruits and it’s price.

Our goal is to locate the fruits and their corresponding prices. Then fill in those prices in column B.

In cell B2 enter the below formula:

• =IFNA(VLOOKUP(A2:A5;D2:E5;2;0);”NOT FOUND”)
• Excel automatically fill in the cells in column B.