Thread: Easy Problem that I can't figure out
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Easy Problem that I can't figure out
Example, in B2: =MATCH(A2,$1:$1,0)
where A2 houses the value to be matched within row1

B2 will return the col "number".
Eg if A2's value is found/matched in C1, B2 will return: 3 (col #3)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cory from Eugene" wrote:
I just want to search a row for a certain value, and then return the column
number that the value is in. Easy right? but I cant figure it out.

Someone help me.

Thanks,
Cory
Reply With QuoteReply With Quote