View Single Post
  #2   Report Post  
Tom Ogilvy
 
Posts: n/a
Default What is the purpose of a lookup function?

if you have a table of values such as
Column A Column B
A 3
B 4
C 8
D 32
E 10


And I wanted to see what number corresponded to D for example. I could use

=Lookup("D",A1:A6,B1:B6)

this would return 32

--
Regards,
Tom Ogilvy


"ERose" wrote in message
...
Excel 2000