Hi guys
I am completely stuck and hope somebody can help me, please!
I basically need to do a VLOOKUP, where I need to find the matching value from one sheet in another sheet, BUT I don't need the value in the same row to its right, I need the value ONE ROW ABOVE.
Does anyone have an idea how I can solve this? I have attached a sample sheet.
Basically, in sheet 1 I need to match the keywords with the URLs in sheet 2.
Sample Excel Problem.xlsx
Bookmarks