| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for a data in excel sheet
Please help me with the formula for the below tables
Shop 1 Shop2 NAME NUMBER OF ITEMS NAME NO OF ITEMS Apples 40 Banana 15 Banana 25 Guava 20 Grapes 30 Pineapples 13 Orange 50 Orange 27 I need the result in the below format. NAME NUMBER OF ITEMS Shop 1 Shop2 Apples 40 #N/A Banana 25 14 Grapes 30 #N/A Guava #N/A 20 Orange 50 27 Pineapples #N/A 13 Instead of #N/A, I would like to get 0. Please help me in this regard. Thanks in Advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for rows in one sheet and copy into another sheet based on customer id | Excel Worksheet Functions | |||
| search a data in excel document | New Users to Excel | |||
| when I search for data in Excel, the found cell cannot be seen | Excel Discussion (Misc queries) | |||
| Is it possible to combine MATCH & IF to search an excel sheet | Excel Worksheet Functions | |||
| how do i search an excel sheet for links to another spreadhseet? | Excel Discussion (Misc queries) | |||
Threaded Mode
