On the Receipt sheet, in cell B4 , use VLOOKUP to get the item description for the item in A4 from the Items sheet On the Receipt sheet, in cell C4 , use VLOOKUP to get the unit price from the Items sheet On the Receipt sheet, edit the formulas in cells B4 C4 to use absolute references for the array range ('Items' A1 D26), and use the fill handle to copy the formulas (without formatting) to cells B5 C6 On the Items sheet, in cell E2 , use an IF() statement to compare the reorder level with the current inventory (HLOOKUP Item ID in the Inventory sheet and return the In Stock value) If the current inventory is less than or equal to the reorder level, display order Otherwise, display stocked On the Items sheet, edit the formula in cell E2 to use absolute references for the array range Then use the fill handle to copy the formula to cells E3 E26 On the Inventory sheet, in cell B3 , use VLOOKUP to get the Unit Price from the Items sheet for the Item specified in B1 On the Inventory sheet, edit the formula in cell B3 to use absolute references for the array range Then use the fill handle to copy the formula to cells C3 Z3

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 26, 2024

On the Receipt sheet, in cell B4, use VLOOKUP to get the item description for the item in A4 from the Items sheet.
On the Receipt sheet, in cell C4, use VLOOKUP to get the unit price from the Items sheet.
On the Receipt sheet, edit the formulas in cells B4:C4 to use absolute references for the array range ('Items'!A1:D26), and use the fill handle to copy the formulas (without formatting) to cells B5:C6.On the Items sheet, in cell E2, use an IF() statement to compare the reorder level with the current inventory (HLOOKUP Item ID in the Inventory sheet and return the In Stock value). If the current inventory is less than or equal to the reorder level, display order. Otherwise, display stocked.
On the Items sheet, edit the formula in cell E2 to use absolute references for the array range. Then use the fill handle to copy the formula to cells E3:E26.
On the Inventory sheet, in cell B3, use VLOOKUP to get the Unit Price from the Items sheet for the Item specified in B1.
On the Inventory sheet, edit the formula in cell B3 to use absolute references for the array range. Then use the fill handle to copy the formula to cells C3:Z3.