look up help required

[Look up help required]

Does anyone know how i can create lookup formulae (or
similar) to give me a column number?
ie. if cell a1 contains the lookup match then the result
would be 1...similar if j1 would be 10?
does that make sense?

 

[Frank Kabel]

Hi
try
=MATCH(search_value,A1:A100,0)

 

[Dave R.]

or for columns;

=MATCH(lookupvalue,A1:Z1,0)

Hi
try
=MATCH(search_value,A1:A100,0)

 

[Gerry]

As always Frank. Many Thanks.

-----Original Message-----
Hi
try
=MATCH(search_value,A1:A100,0)

--
Regards
Frank Kabel
Frankfurt, Germany


.

 

[JE McGimpsey]

One way:

=MATCH(Lookup_Value,1:1, FALSE)

 

[Guest]

Thanks Dave

-----Original Message-----
or for columns;

=MATCH(lookupvalue,A1:Z1,0)




.