I want to compare data of two sheet and need output from another column if match

[haritgautam]

i have three sheet a, b & c , all three sheets contain customer id number. in sheet c all customer reward point is updated… now what want is to compare sheet a & c data,if customer id is match than the reward point of this particular customer auto populate in sheet b… in simple language compare-find-update in new cell

[mariosv]

You should try to do it with functions like VLOOKUP or MATCH. Functions help