Matching values
I need to find out if a record is in a database
--> the Record is a mixture of text and number hence i am lost about what to do.
Example
i want to check if "S9050423A" appears in another excel file.
if it appears, the cell will reflect "yes"
else
it will reflect "no".
may i know how to go about it?:|
i been seeing examples but am still confused.
hi there. you mentioned "another excel file", so you have 2 excel files? assuming "S9050423A" on formula file in cell A2.
do this on the file you are going to input the formula,
=COUNTIF(
refer to the file which you want to find "S9050423A". it could be in column F for eg. click on column F. it should turn out like:
=COUNTIF([Book2]Sheet1!$F:$F
put comma and refer to A2, where "S9050423A" is at. do a close parenthesis. press ENTER
=COUNTIF([Book2]Sheet1!$F:$F,A2)
that counts how many times "S9050423A" appeared in another file. if you want yes or no, add in the IF formula:
=IF(COUNTIF([Book2]Sheet1!$F:$F,A2)>0,"yes","no")
both files must be open for it to work.
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
TQ!appreciate your help!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks