Matching one cell to multiple columns

[Fratshack]

Hello everyone,

I am new here and quite the idiot with excel it seems.
I have been looking for months now and trying to figure out how to match one cell against multiple columns.
I have numbers in columns a through cc and cannot put them in descending order.
I am using this formula =match(CF1,A10:A1008,0)
I have to use a new cell and type the same formula =match(CF1,B10:B1008,0)
then again =match(CF1,C10:C1008,0)
I AM RUNNING OUT OF ROOM!
Is there anyway to search all columns =match(CF1,A10:CC1008,0) ??????
This formula doesn't work when I type it in.

I have tried shift control enter for an array and still no go.
I have tried vlookup
I have tried Index
I have tried Iferror
I have tried isna
Oh sweet baby jesus!
Please HELP!

[Richard Buttrey]

Hi,

Can we start from basics. What do you want to do if you do find a CF1 match in any of columns A:CC?

Do you
a) just want to know that fact
b) identify the cell or cells that match by noting their address or in some other way
c) something else

[Fratshack]

Sorry if this is posting multiple times as I don't see it after I post a reply.

Thanks for your help Richard and I hope you are enjoying the holidays.
I just need it to work like the match function normally does by displaying the cell row where the match is located.