HI..
Use (VLOOKUP($H2,Sheet1!$B$2:$E$24,3,0)) for A & B results in next sheet and pls let me know wht is the criteria for pass & fail?? is there any number decided like for e.g."100",if exceeds, passes or fails??
Please find the attached sheet for vlookup
Bookmarks