EXCEL IF() Statement?

  • Thread starter Thread starter field1
  • Start date Start date
F

field1

As a first time "poster" — I have a workbook with 2 worksheets. My cel
needs to go and reference the contents of a cell (text or a number) o
the 1st worksheet and check to see if it exists in a column (range
text or numbers,in the other worksheet — if the number is in the list
I need it to print out text. I'm not sure how to do it
BY
 
Hi
try
=IF('sheet1'!A1<>"",IF(ISNUMBER(MATCH('sheet1'!A1,'sheet2'!A1:A100,0)),
"print text","not found"),"")
 
Sounds like you want to compare lists, and if an item is in the other list,
return that item?

if you want your formula on sheet1 to look at items in A1:A100, try in B1
(sheet 1)

IF(COUNTIF(Sheet2!A$1:A$100,A1),A1,"")

and copy it down to B100. This looks in sheet2! at the range A1:A100, and be
sure and use the $ signs so you can copy the formula down without the range
changing.
 
Back
Top