jeudi 5 octobre 2017

Read value on Sheet1 from Sheet2 using vlookup

I have the following on Sheet1:

Sheet1

Then on Sheet2, I have data. Following is the image.

Sheet2

I want to read the today's and tomorrow's for all the fruits from Sheet2 to Sheet1

I tried vlookup, but it didn't give me a right answer. It was confusing. I also tried to incorporate an if statement with the vlookup, but that made it more confusing.

Aucun commentaire:

Enregistrer un commentaire