Populate one sheet with data from a different sheet based on similar cells

**DirtyTech** · 02-29-2012, 04:51 PM

Hi sorry I'm really not sure how to describe this so I had a hell of a time searching for the info.

Basically I have two spreadsheets, spreadsheet A has a list of URLs and some info in a cell adjacent to each URL. I also have another sheet, spreadsheet B has a bigger list of URLs also with data next to each URL. The URL lists are not identical but contain similar urls, I want to add a new column of info on sheet A that's pulled from the cell adjacent to the exact same URL on sheet B. I have no idea how to do this and having a hard time describing it here, I hope this makes sense.

Thanks!

**jbhamra89** · 02-29-2012, 05:10 PM

So you want to find out the matching urls from sheet A and sheet b?

if that isn't the case, mind putting up a sample?

**DirtyTech** · 02-29-2012, 05:20 PM

yea, for instance if I have a url in A1, I have some other data in B1 then I need C1 to pull data from a cell in sheet B - the cell in sheet B the that C1 pulls should come from a cell next to the cell that matches the url in sheet A cell A1. So I guess it'd have to search an area for a match and grab the adjacent cell. Is this possible?

**FDibbins** · 02-29-2012, 06:44 PM

sounds like a vlookup would work for you.
=vlookup(what_you_want_to_find,range_where_all_the_data_is,column_to_look_in,false)

when you create the formula, make sure you absolute ($) the data range so that when you copy it down, the data range reference remains the same