Display

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Guys,
Need help with the following spreadsheets.

Have 2 spreadsheets. Sheet #1 contains inventory query
information, Such as Date, Manf. Product, description,
current inventory count, normal shelf count and re order
amount.
Sheet #2 contains contains a vlookup formula to display
the proper information from Sheet #1.

My Question pertains to the re-order quantities on Sheet
#2. I want to manually enter the current shelf quantity
and display the difference between the shelf count and
the inventory count in Sheet #1 but I want to display the
result in the re-order cell on Sheet #2.

Thank for your help.

Stan Anderson,
Salt Lake City, Utah
 
I guess that I don't quite follow your question.

Just add a column, and subtract one from the other, and then create another
lookup formula which returns the results of that new column.

But I'm sure you thought of that.
So maybe rephrase the question.
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi Guys,
Need help with the following spreadsheets.

Have 2 spreadsheets. Sheet #1 contains inventory query
information, Such as Date, Manf. Product, description,
current inventory count, normal shelf count and re order
amount.
Sheet #2 contains contains a vlookup formula to display
the proper information from Sheet #1.

My Question pertains to the re-order quantities on Sheet
#2. I want to manually enter the current shelf quantity
and display the difference between the shelf count and
the inventory count in Sheet #1 but I want to display the
result in the re-order cell on Sheet #2.

Thank for your help.

Stan Anderson,
Salt Lake City, Utah
 
Back
Top