dimanche 7 février 2016

How to compare a string within a string list in Excel

Hi guys, I am trying to write an if statement in Excel but I could not find the right way to make what I need

There are some food names and prices as you can see between I2 and J22. For instance AYÇICEK YAĞI(SUNFLOWER OIL IN ENGLISH) is 4$ per kg. In the left of the sheet, you can see other list. What I need is;

I want to compare all A* columns with Strings between I2:I22 and get the price which is written between J2:J22 then write it to the D* columns.

There are more than 500 rows and I need to do it for all rows.

And there are some headings as u can see in bold font, they should be protected.

Aucun commentaire:

Enregistrer un commentaire