Hello There,
I've got a little bit stuck a formula so looking for a bit of help please.
In the attached Workbook I have the following tabs:
'PO Log'
'Jays Product Stock'
I managed to figure out how to look up 'Bin Loc' from 'PO Log' to pull Column H into 'Jays Product Stock' but now I want to be able to pull the corresponding 'Qty' in Columns C, E, G on 'PO Log' into Column D 'Jays Product Stock'.
Thanks
I've got a little bit stuck a formula so looking for a bit of help please.
In the attached Workbook I have the following tabs:
'PO Log'
'Jays Product Stock'
I managed to figure out how to look up 'Bin Loc' from 'PO Log' to pull Column H into 'Jays Product Stock' but now I want to be able to pull the corresponding 'Qty' in Columns C, E, G on 'PO Log' into Column D 'Jays Product Stock'.
Thanks