how to pull data from one sheet and add to another sheet

[rexmonster]

Hi,

I have a workbook with data on different sheets. The common link between the data are the title names (in text). I need to be able to have a function entered on the first worksheet that will search the second worksheet for the matching title and return the sale information associated with that title on the second sheet. I thought that vlookup would have been able to do this but it looks like vlookup only searches values not text?!

Could you provide a function that would enable this kind of search request and return the desired data?

Example:
HAVE
[sheet1]-title, seller, inventory number
[sheet2]-title, sale date, buyer, order number, sale price, commission
WANT
[sheet1]-title, seller, inventory number, sale date, buyer, order number, sale price, commission

Thanks for any help you can provide me,
Rex

[swatsp0p]

Hi, Rex. VLOOKUP should work for you. We need to make sure your data is in the proper format first, though, to make it work. Your data on sheet2 MUST be sorted ASCENDING by the first column (and that will be your lookup value). In this case, it is your Title. I would also name this entire range on sheet2 as "Table1" or similar.

Then, back on sheet1 we'll insert the formulas to pull the data from Table1.

I will assume you begin in A2 with your data, Title. Therefore, in D2, enter this:

=VLOOKUP($A2,TABLE1,2,0)

E2 will be: =VLOOKUP($A2,TABLE1,3,0)
F2: =VLOOKUP($A2,TABLE1,4,0)
G2: =VLOOKUP($A2,TABLE1,5,0)
H2: =VLOOKUP($A2,TABLE1,6,0)

Copy this formulas down your range on Sheet1

NOTE: the spelling must match exactly to return the appropriate data. Capitalization is not important, but "Mr. Smith Goes to Washington" is different than "Mr Smith Goes to Washington" (note the missing '.' after Mr.)

Good Luck

Bruce

[rexmonster]

Thanks Bruce for the help. I will give this a whirl!

Regards,
Rex