I have 2 sheets . One that shows me a part number description and qty on open orders at I have through a pivot table . I have another sheet for my inventory that shows Part number description and on hand qty. I want to do a vlookup on the open orders to show me how many I have on hand to fill these orders. can't get the formula right. The sheet with open orders uses cells a2-C2 down to a48-c48 The qty on hand as columns a2-c2 down to a5055-c5055. Can anyone help.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Vlookup for 2 sheets same workbook
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,738
- Office Version
- 365
- Platform
- MacOS
you have 3 columns
I'm Assuming
A = part number
B = Description
C = Quantity
In sheet "inventory" shows on hand quantity A2:C5055
A pivot table with open orders
if the pivot table is updated , then this will stop working
lets assume you have a free column E
and on the pivot table it starts at A2 : C48
part number on A2
=Vlookup( A2, inventorySheet!$A$2:$C$5055, 3 , false)
should return the value on hand
copy down the pivot table to row 48
I'm Assuming
A = part number
B = Description
C = Quantity
In sheet "inventory" shows on hand quantity A2:C5055
A pivot table with open orders
if the pivot table is updated , then this will stop working
lets assume you have a free column E
and on the pivot table it starts at A2 : C48
part number on A2
=Vlookup( A2, inventorySheet!$A$2:$C$5055, 3 , false)
should return the value on hand
copy down the pivot table to row 48
Last edited:
Upvote
0
Similar threads
- Question
- Solved
