N/A Item

[lazytkina1]

I have the data with items number on one sheet and another sheet I have table with items and prices. How can I set it up two sheets to mach if I am missing item in my data.Do I need create a sheet 3 for identify my N/A #.
Sorry, I have attached wrong file, See below

Thank you,

Kateryna

[shukla.ankur281190]

I think you have putted wrong Xl file.

[lazytkina1]

If I get a new item from Data, how can I set the sheet for identify new item, what is not in my main sheet with price and total.

Thank you,

Kateryna

[shukla.ankur281190]

If you want to check your data sheet with Table sheet you will first insert a sheet naming Checking Sheet.Make header like your Table sheet in Checking sheet after that you will have to put below formula in checking sheet as below in A2 cell with Ctrl+Shift+Enter and drag it down..

Please Login or Register  to view this content.

Now you will have to put in checking sheet below formula in B2 and drag it to B2:F7 or more according your need.

Please Login or Register  to view this content.

Sample file is attached.

Hope this is what you looking for.