dear, I need help. For Example, IF we have many entries against value "A" than how I can pick the latest date value using the formula in excel. and if I have many entries of different values how I can pick the latest date value. (Sorry For My English)

i have two sheets, Sheet No 1 has Selling date, Grade & Item Code, Sheet no 2 has Price applicable from date, to date, Item code & Garde. please help to solve using vlookup, index or any other function in excel ?

Hello, what if I want to add another criteria. For example, if there was another column D called "Group ID" that I want to add in the formula. i.e. If group ID=302511 then LOOKUP(2,1/($A$2:$A$7<=F1)/($B$2:$B$7>=F1),$C$2:$C$7). Is this possible?

I think it's because that's the number of lookup factors you have. I tried it with three factors and I used 3 as the lookup value. I'm not sure exactly, but I think by putting "3" and then using the "/" to separate the lookup vectors you tell Excel to search for the three following inputs to return the output.