Check if items in textboxes already exist in a row

[kelly mort]

Hi,

I want to check if the inputs from textbox2 and textbox5 already exist in my database.

That's textbox2 entry is going to column C and textbox5 entry is pointing to column F.

The data starts from row 2 . Row 1 is header.

So say I have in textbox2, "Cat" and in textbox5, "green".

And in row 2 I have "cat" in column C and also have "green" under column F, same row 2, then you alert me both items exist in same row.

So we are checking rows down say up to row 10 for those matches. Then pop the alert.


I can do with countif with just one item. But the two is tougher.

I need help with that.

Thanks

 

[Fluff]

You can use Countifs rather than Countif
https://exceljet.net/excel-functions/excel-countifs-function

 

[kelly mort]

You can use Countifs rather than Countif
https://exceljet.net/excel-functions/excel-countifs-function

Fantastic! !!


Faster than I thought.

 

[Fluff]

You're welcome & thanks for the feedback