BUT you have used lookup function what ur quary says.. u need vlookup..for that you have to make a table showing in out ranges and dats it