I just need to know if Excel acknowledges the results of a formula and is able to reference said result in a new formula. The two formulas are as follows:
Resulting in the SKU number i need from Sheet1 to be in Sheet2
=vlookup(D3,Sheet1!$a$1:$h$1677,1,FALSE)
This returns the SKU number I need into Sheet 2, F column, based on the Item # I already have in sheet 2. This formula is working properly and is not the problem
THIS is the problem:
NOW I need to return the order amount from Sheet 3 based on the SKU i just looked up in Sheet1 and now have in Sheet 2.
=vlookup(F2,Sheet3'!$a$1:$h$1677,3,FALSE)
The problem I have is that I need to use the item number to find the sku number, then need the sku number to find the order amount. BUT NONE of these sheets have all 3 items in it.
Bookmarks