Ask Your Question
0

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

asked 2017-07-28 11:15:47 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-07-29 00:09:59 +0100

m.a.riosv gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-28 11:15:47 +0100

Seen: 564 times

Last updated: Jul 29 '17