Master advanced Excel techniques with this in-depth tutorial. Learn how to use Excel for accounting and finance with tips from an Excel expert. Includes Excel formulas, macros, pivot tables and more.
I have two spreadsheets First spreadsheet has 4 columns: Roll No., Name, Fruit, Quantity 1111 AAA Apple 3 2222 BBB Orange 1
Second Spreadsheet has COLUMN HEADING AS: Roll No. APPLE ORANGE MANGO (Fruit) in column heading
Now I want formula in second spreadsheet in B2 that if data VALUE OF cell A2 and B1 (i.e. column heading) matches in First Spreadsheet then put the value of D2 in B2 (relative formula is required)
as salamualikum sir g ye file kahan se downlode karsakte he plz mere mail mer send kigiye na sir g mehboob_khan2002@yahoo.com
ReplyDeletei need this file
ReplyDeletesattamalsoso7@gmail.com
I have two spreadsheets
ReplyDeleteFirst spreadsheet has 4 columns:
Roll No., Name, Fruit, Quantity
1111 AAA Apple 3
2222 BBB Orange 1
Second Spreadsheet has COLUMN HEADING AS:
Roll No. APPLE ORANGE MANGO (Fruit) in column heading
Now I want formula in second spreadsheet in B2 that if data VALUE OF cell A2 and B1 (i.e. column heading) matches in First Spreadsheet then put the value of D2 in B2 (relative formula is required)