Thread: Exceeding the limit for Nested IFs
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sige
 
Posts: n/a
Default Exceeding the limit for Nested IFs
Hi Beard,

I think this is what you are looking for:
=INDEX(PB!A1:B8;MATCH(B3;(PB!A1:A8);0);2)

HTH Sige

Reply With QuoteReply With Quote