Thread
:
if function
View Single Post
#
2
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_]
external usenet poster
Posts: 913
if function
On Tue, 19 Jan 2010 14:50:02 -0800, Pinnacle Accounting <Pinnacle
wrote:
in A1,A2 and A3 i have the salesperson name, in B1,B2 and B3 i have the sales
person employee number.
in A7 i have to input the sales person number and i would like their name to
atuomatically show up on B7, i was thinking that if a used the If function i
could achieve this
please help asap
thanks
Try this formula in cell B7:
=INDEX(A1:A3,MATCH(A7,B1:B3,0))
Hope this helps / Lars-Åke
Reply With Quote
Lars-Åke Aspelin[_2_]
View Public Profile
Find all posts by Lars-Åke Aspelin[_2_]