Ask Your Question

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

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-11 14:35:32.437218

1 Answer

Sort by » oldest newest most voted

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

Question Tools

1 follower


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

Seen: 700 times

Last updated: Jul 29 '17