View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sudha Sudha is offline
external usenet poster
 
Posts: 1
Default 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