How to Compare collum A to a specified input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there!

Im lost. And im not that god at english writing. Hope you can read. From
sweden by the way

So this is what i try to do. I got a list of specified numbers and i need to
compare with a nother list in an diffrent program... So i think lika
this....Make a list off numbers i A take like C2 and make it to a input box
for compare number. And make this input compare with the numbers i A.... Then
if it+s posible to get a answer like Exists or Not exists in C4..

It this possible at all????

Mail me please at (e-mail address removed)
 
Hi Richard

by a different program do you mean another excel workbook (*.xls), another
worksheet or another computer application (Access, Word, etc)? If it is
another workbook or worksheet then I think a read of Chip Pearson's website
http://www.cpearson.com/excel/duplicat.htm especially the last two articles
on this page could help you.

Alternatively, you might like to look at the MATCH function
=MATCH(value_to_find, range_with_values,match_type)

=MATCH(5,A1:A100,0)
will look for the number 5 in the range A1:A100 and return the position of
it in the list if it is found or #NA if it isn't. You can then nest this in
an IF statement to get the "Exists", "Not Exists" answer
=IF(ISNA(MATCH(5,A1:A100,0)),"Does not exist","Exists")

Hope this helps
cheers
JulieD
 
Back
Top