For Money Receipt in Excell

The formula will be in Sheet 2 F8. I want to read a Form number from Sheet 2 B1 wchich form number is also in Sheet 1 C2. Which will read the address of the respective form number. The address is given on Sheet 1 L2.

 

Please help me out.

 

Entered this formula but not working

=VLOOKUP(B1,’Sheet1′!$A$2:$X$10,9,FALSE)

By: Pial Banerjee

Leave a Reply

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