Hi Everybody,
I have attached one excel sheet which is having two sheets named as Predata and Problem.
In Predata sheet it has two columns named as Keyword and URL.
In Problem sheet it has two columns named as Keyword1 and URL1 but URL1 is empty which need to be filled using VLOOKUP.
The keywords which are present in Predata are also present in Problem sheet.
So my question is how to use VLOOKUP to fill the empty column URL1 with respective urls from Predata sheet.
For other keyword it should show "N/A" or blank.
Please find the excel sheet to see the problem.
Any suggestions or help is highly appreciated.
Thanks in advance.
Bookmarks