help creating an excel document for the football tote/lottery please

[Tigi]

Hi, to save hubby time, I have created an excel doc that will list all of the football players names, and their tote numbers. They draw the tote weekly and pick 2 numbers. At the moment they leaf through vast numbers of paper to find the winners. So, anyway, i have prepared a document that will list the player, and their numbers (they can pick up to 5). If I use edit, and search, I can look for one number at a time.
Question - can I look for two numbers - so the job can be done all in one go? Or can i fix the search so that it highlights all the searched numbers prior to the search of the second number?

Hope that makes sense! ta

Hmmm.

Ok, this is excel, right?

This is how I would do it:

1. Set up two cells that you put the winning numbers in. Let's say these are F1 and G1
2. Set up an @If type column on the regular columns. Let's say this column is column C, and the regular numbers are in column B. I would use a formula like: =+IF(OR(B1=$F$1,B1=$G$1),TRUE,FALSE). Then copy the formula down column C.
3. Use data-filter to select only rows where C is TRUE.

okay.......... not ever so techie, but I'll have a go! my table I have set up is very simple really! I'd tried to search online for a template, but not found anything. So its just a table, that i would then search through. i'll have a fiddle and see!

I tried with NQC but struggled to make much sense!

I have column 1 - names, 2 is numbers (and more!)

i will try then next bit after tea........ Thanks for both of your help!

littlelapin's method is probably easier than mine. I've never used vlookup.

nooo, didn't work..........

Ok, look, just mail it to me. I'm @gmail.com.

I'll set it up so it sorts it out for you.

Bump this thread when you've sent it, as I don't normally check that email account.

Thank you , thats really kind, but I don't like to trouble you! I thought it would be something simple to do! I now have an excel manual, so was going to have a look at that. I'll do that first, and see how I get on! Thanks again.

Ok, well, doing it would be easier than explaining it, tbh.

vlookup is a command from a program used before excel became the standard. Can't even remember its name now.