Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compare and Copy

Status
Not open for further replies.

s2welee

IS-IT--Management
Oct 8, 2007
12
US
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.
 




Hi,

Check out the VLOOKUP function.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
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.
 




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]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
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.
 



[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]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Thanks so much. It helps to see an example that works for my data. I think I have it now.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top