Compare and Copy

[s2welee]

I have an issue that I am sure involves a pretty simple formula. I have two spreadsheets, one with a bom including part number, and the other is a list of all parts with pricing. I would like to pull the pricing based on the part number from sheet 2 and instert it into the correct place on sheet one so that I have a bom with the correct part price. Please help. Thanks.

 

[SkipVought]

Hi,

Check out the VLOOKUP function.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[s2welee]

Can that span worksheets? All the examples that I see only show pulling data from the same sheet. Thanks for your help. If it can, it looks like a winner.

 

[SkipVought]

When you build your formula, when it comes to cell or range references, simply click on the CELL, for eacmple for the LOOKUP VALUE...
[tt]
=vlookup(
^here's where to click on the cell value that you want to lookup on the other sheet
[/tt]
and then to reference the lookup range...
[tt]
=vlookup(A2,
^here's where to 1) select the other sheet and 2)select the RANGE on that sheet where the lookup values and return values will be
[/tt]
so it might look something like...
[tt]
=VLOOKUP(A2,Sheet2!A1:B999,false)
[/tt]




Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[s2welee]

I do not mean to be a total idiot, but I am just not getting this. Here is my scenario. My part numbers are in column D on sheet one and A on sheet two. The prices that I want to return are in column S of sheet two. If you could give me the proper syntax I would greatly appreciate it. Sorry again for the noob questions.

 

[SkipVought]

[tt]
=VLOOKUP(D1,Sheet2!A:S,column(s1),false)
[/tt]
assuming that your lookup table is on Sheet2.

Check HELP to understand how VLOOKUP works.


Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[s2welee]

Thanks so much. It helps to see an example that works for my data. I think I have it now.