LinkBack URL
About LinkBacks
Hi, i have 3 sheets with data in a particular row(A). On fourth sheet i want to get comparision of datas in three sheet. Is there any way 2 do that? Check the attachment for clear view of my question.
Data mapping between sheets
Hi, i have 3 sheets with data in a particular row(A). On fourth sheet i want to get comparision of datas in three sheet. Is there any way 2 do that? Check the attachment for clear view of my question.
Last edited by scorpy; 10-23-2010 at 01:26 AM. Reason: Solved:)
This formula in C4 will give the results you asked for (dragged right and down). Your ID's in vaca3 are incorrect as they do not have the space in them. If you fix that, you'll get the same as your example. Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanx for ur heads up, but what formula u r talking about?
LOL, I'm sure I pasted the formula into that post....really I did.
=IF(ISERROR(VLOOKUP($B4,INDIRECT(C$3 &"!$A$2:$A$30"),1,FALSE)),"","x")
Does that work for you? Any questions?
Re: Data mapping between sheets
Thanx a lot.That worked. Kudos2 u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks