@Riny_van_Eekelen thank you for the answer. It works, but in my situation i have the raw data into another worksheet where I regularly update with new information. Will vlookup work with different worksheet?
Yes it will work across workbooks. Say your raw data sits in "Book1". Make sure your formula looks like this: =VLOOKUP($A$2,[Book1]RawData!A:G,2,FALSE)
You can make the formula easier to maintain (if applicable) when you create a named range for your table that contains the raw data. So, if you would name the range of columns A to G in sheet "RawData" to e.g. "DataList" the formula would become:
I also find such formulae easier to read. But that's just my personal opinion.