I think I have a basic excel lookup question. I am using Excel 2007 and simply have two worksheets within a single workbook. One sheet has the item numbers and the prices, and the other has more detailed information. I simply want Excel to search the Price List sheet for the Part #, and enter the price into the appropriate field on the Item Details sheet. I have attached an example spreadsheet that I created. I think it might be a vlookup or lookup function but am unsure. Thank you! So if item B20 is $5.23 on the Price List, I want Excel to search for item B20 in the Price List and enter the Price for that item into the Item Details sheet. Hope that makes sense!