Excel - Updating data in a cell based on compare of two other columns 1

[tomw99]

I have two sheets:

Sheet One

Item# - Description - Price
12345 - Orange - ?????


Sheet Two
Item# - Description - Price - Units......Much more data
23456 - Apple - $2.33
65432 - Pear - $1.45
12345 - Orange(LB) - $1.89


I need a formula for the price cell in sheet one that will look for the matching item number in sheet two and update the corresponding price on sheet 1. The order of the items and the descriptions of the items on sheet 2 will not normally match sheet one and sheet one.

Thanks
Tom

Hope this makes sense.

 

[methoni]

use this formula:
=vlookup("cellinsheet1","datarangeinsheet2",3,false)

the items in quotes are your cell addresses.


Good luck!

 

[tomw99]

Thanks.... that was the perfect solution!!!