VLOOKUP is what I'm using, [=VLOOKUP(A2,'All Computers_AP1'!A:A,2,FALSE)] and [=VLOOKUP(A2,'All Computers_ADASIAPAC'!A:A,2,FALSE)]. How can I show my result in word of 'Found' or 'Not Found'? Attach with my Template for your better review. Thanks, Newbie OUT!
I have 3 sheet. Sheet1 (RowA) is the 'Target', sheet 2(RowA) and 3(RowA) are the 'Source'. Sheet1(RowD & E) are the result found after comparison with sheet2 and 3.
Last edited by DonnyLau; 06-12-2013 at 08:26 AM.
hi DonnyLau, welcome to the forum. COUNTIF seems sufficient.
=IF(COUNTIF('All Computers_AP1'!A:A,A2),"Found","Not Found")
=IF(COUNTIF('All Computers_ADASIAPAC'!A:A,A2),"Found","Not Found")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
FYI, the reason you are getting a #REF error is that your VLOOKUP is asking to return information from the second column but you only put in a range of 1 column
=VLOOKUP(A124,'All Computers_ADASIAPAC'!A:A,2,FALSE)
should be
=VLOOKUP(A124,'All Computers_ADASIAPAC'!A:B,2,FALSE)
or
=VLOOKUP(A124,'All Computers_ADASIAPAC'!A:A,1,FALSE)
Hope that helps in the future.
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
Thanks ChemistB and Benisiryo both Guru. Both formula Works to me!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks