Hi All
I have a spreadsheet (see attached) of URLS in two seperate columns and am trying to
Look for the URL's from column A and look for a match in Column I. If there is a match then I want to insert the average Position of that match from Column L into column F.
Any takers. I have tried the normal LOOKUP and VLOOKUP but struggling to get this to work.
I think it may have something to do with the numerous symbols within the url address.
Kind Regards
Glen
glenws,
In cell F2 and copied down, give this a try:
=IF(ISNA(MATCH(A2,$I$2:$I$90,0)),"",VLOOKUP(A2,$I$2:$L$90,4,FALSE))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
=VLOOKUP(A2,I:L,4,0)
worked for me, but there are alot of URLs that are not in both lists, they are returning #N/A so you can use this
=IF(ISERROR(VLOOKUP(A2,I:L,4,0)),"NOT FOUND",VLOOKUP(A2,I:L,4,0))
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
You can put this formula in F2:
=IFERROR(MATCH(A2,I:I,0)-ROW(),"")
and copy down. It will give you a blank if there is no match, but with a match it will give the relative "standing" for each row, i.e. the movement of that row compared with the previous month's position - a negative number means that it has moved down. Is this what you meant?
Hope this helps.
Pete
EDIT: Ah, I see that Average Position is one of the columns in your second table - I thought you were talking about the movement each month, rather like a league table. Disregard my offering.
Pete
Last edited by Pete_UK; 04-20-2012 at 11:10 AM.
Thankd for the quick response. Both formulas work a treat.
Tahnks again
glad to help, could you please makr this thread as solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks