M
MC
Hi,
I have a database:
id Market Part date
101 US n7221 March 22nd
102 US n8810 March 23rd
103 EU t7200 March 24th
From that, I extract the data I want with a simple Xl
sheet form with formulas in each cells:
Enter id: 102
It returns automaticly this:
Market: US
Part: n8810
Date: March 23rd
I use variation of this formula for each cell of Market,
Part and Date:
=IF(ISNA(VLOOKUP(J4;Production_Dashboard!
$A$2:$D$227;3;0));0;VLOOKUP(J4;Production_Dashboard!
$A$2:$D$227;3;0))).
Can I add something to my formula that links directly to
the database that lets me change the date for example ?
Is there a simpler way to do this? Is there a formula
that would let me paste the value at the right place in
the database ?
Need help!!!
MC
I have a database:
id Market Part date
101 US n7221 March 22nd
102 US n8810 March 23rd
103 EU t7200 March 24th
From that, I extract the data I want with a simple Xl
sheet form with formulas in each cells:
Enter id: 102
It returns automaticly this:
Market: US
Part: n8810
Date: March 23rd
I use variation of this formula for each cell of Market,
Part and Date:
=IF(ISNA(VLOOKUP(J4;Production_Dashboard!
$A$2:$D$227;3;0));0;VLOOKUP(J4;Production_Dashboard!
$A$2:$D$227;3;0))).
Can I add something to my formula that links directly to
the database that lets me change the date for example ?
Is there a simpler way to do this? Is there a formula
that would let me paste the value at the right place in
the database ?
Need help!!!
MC