Thank you everyone for the suggestion, I am able to do so with simple VLOOKUP. For some reason there was an error on my lookup so couldn't get what I was looking for but now it is fixed.
Thanks again for your time and effort.