EXCEL HELP

Hi, I have to create a searcher using INDEX and MATCH function in Excel. I’ve made a billionaire’s datasheet in a seperate sheet in the same workbook. I want it to work like; when someone types in the name infront of the name input cell, it searches for it in the datasheet and autofills rest of the data itself.

  Billionaire’s Search
     
Name Input  
First Name     
Net Worth    
Rank    
Residence    
Sources of Wealth    

By: ZAK

Leave a Reply

Your email address will not be published. Required fields are marked *