Thread: Please help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
  
Posts: 510
Default Please help
Hi Heather,

With a reference table in g1:h10, a lookup function should do the job :
=Vlookup(a1,g1:h10 ,2)

HTH
Cheers
Carim

Reply With QuoteReply With Quote