I really should know how to do this, I suspect it is quite simple.
I have two Worksheets, they both contain one column which has an ID, the ID identifies the same products in both sheets. One sheet has one sellers price for that product and the other sheet has another sellers price for that product, what I want to do it show on either sheet what the two different prices are for that ID.
So "IF the ID = 100 in sheet 1 return the price of ID = 100 from sheet 2 to column X in sheet 1"
Does that make any sense at all?