List number

[NCIII]

a1=1 b1=25
a2=2 b2=24
a3=3 b3=23
a4=4 b4=22
a5=5 b5=21

c1=23

=IF(c1=b3,a3,0) works. I need a formula that will search b1 - b5 for a
match to c1 and print the number in a1 - a5. Thanks.

 

[Bernard Liengme]

Try LOOKUP

 

[Frank Kabel]

Hi
try
=INDEX(A1:A4,MATCH(C1,B1:B5,0))

 

[NCIII]

HI Frank,
Formula works great...many thanks.

Hi
try
=INDEX(A1:A4,MATCH(C1,B1:B5,0))