Easy Problem that I can't figure out
Do you want the relative column number or the absolute column number?
Assume you have this data in E1:J1
10, 96, 21, 47, 99, 35
You want to lookup the column number for the number 10.
For the relative column number:
A1 = 10
=MATCH(A1,E1:J1,0)
Returns 1
For the absolute column number:
=INDEX(COLUMN(E1:J1),MATCH(A1,E1:J1,0))
Returns 5
--
Biff
Microsoft Excel MVP
"Cory from Eugene" wrote in
message ...
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
|