IF Formula

[Evie76]

I have this formula =IF(ISNA(VLOOKUP(B2,CC_Tracker!B5:B4745,1,FALSE)),"No","Yes") that allows me to search a different sheet and if the reference number appears it puts Yes and if it doesn't then it puts No. This works perfectly for searching on one sheet but i need to check three different sheets. I have tried a few ways but they don't seem to work, can anyone help?

 

[MyFace2]

are all the sheets in one workbook? and would you have mixed results on the sheets? i.e. one sheet is "Yes" and two are "No"?

 

[Joe4]

If you are just trying to determine if it exists, and are not concerned with returning a value, you can use COUNTIF instead of VLOOKUP. That will just count how many matches you have.
If greater than 0, then you know it is found. So you could do something like this:
=IF(COUNTIF(sheet1) + COUNTIF(sheet2) + COUNTIF(sheet3) > 0,"Yes","No")
where you just fill in the range and criteria for each sheet in the formula structure above, i.e. the first one would look like:
COUNTIF(CC_Tracker!B5:B4745,B2)
based on your original posting.

 

[Hebustetram]

A search across consecutive sheets is called a 3D reference. It follows the format Sheet1:Sheet3! In your example something like CC_Tracker:CC_Tracker2!B5:B4745
MS 3D official

 

[Joe4]

A search across consecutive sheets is called a 3D reference. It follows the format Sheet1:Sheet3! In your example something like CC_Tracker:CC_Tracker2!B5:B4745
MS 3D official

I don't think that will help in this case.
If you take a look at the list of functions that this is available for (in the link you provided), VLOOKUP and COUNTIF are not listed as options.
SUMPRODUCT isn't even listed either.
I really do not see any functions listed there that you could use in this case (basically, no functions with conditions/criteria are listed).