Stubby
Board Regular
- Joined
- Mar 5, 2002
- Messages
- 188
Hi
I have some data set out as follows:
BB-7865 $54.99 BB-7866 $54.99 dB-7865 $76.00
EM-3741 $125.99 EM-3742 $55.99 dM-3741 $77.00
GR-0876 $99.99 GR-0878 $56.99 dR-0876 $78.00
JH-0678 $33.98 JH-0679 $57.99 dH-0678 $79.00
ST-2472 $63.99 ST-2473 $58.99 dT-2472 $80.00
TY-9868 $169.99 TY-9866 $59.99 dY-9868 $81.00
WE-5493 $44.99 WE-5491 $60.99 dE-5493 $82.00
ST-2471 $54.75 ST-2477 $61.99 dT-2471 $83.00
I have another cell with a value ie ST-2473
is there any function (non VBA) that will allow me to search all of the above and then return the correct price for ST-2473.
I have some data set out as follows:
BB-7865 $54.99 BB-7866 $54.99 dB-7865 $76.00
EM-3741 $125.99 EM-3742 $55.99 dM-3741 $77.00
GR-0876 $99.99 GR-0878 $56.99 dR-0876 $78.00
JH-0678 $33.98 JH-0679 $57.99 dH-0678 $79.00
ST-2472 $63.99 ST-2473 $58.99 dT-2472 $80.00
TY-9868 $169.99 TY-9866 $59.99 dY-9868 $81.00
WE-5493 $44.99 WE-5491 $60.99 dE-5493 $82.00
ST-2471 $54.75 ST-2477 $61.99 dT-2471 $83.00
I have another cell with a value ie ST-2473
is there any function (non VBA) that will allow me to search all of the above and then return the correct price for ST-2473.