In Worksheet A I have a monetary value in Cell A13 - I am trying to derive a value in Cell A40 that references Worksheet B for the resulting value based on Cell A13:
________________________________________________________
Worksheet B looks like this.
Column A Column B
$1,300 $400
$1,310 $410
$1,320 $420
$1,330 $430
$1,340 $440
$1,350 $450
_______________________________________________________
If the value in A13 is $1,301, I would want A40 to equal $400. If the value in A13 is $1,335 I would want A40 to equal $430. If the value in A14 is $1,340 I would want A40 to equal $440.
What formula would I need to use in A40 to derive the correct value from Worksheet B.
Thank you.
________________________________________________________
Worksheet B looks like this.
Column A Column B
$1,300 $400
$1,310 $410
$1,320 $420
$1,330 $430
$1,340 $440
$1,350 $450
_______________________________________________________
If the value in A13 is $1,301, I would want A40 to equal $400. If the value in A13 is $1,335 I would want A40 to equal $430. If the value in A14 is $1,340 I would want A40 to equal $440.
What formula would I need to use in A40 to derive the correct value from Worksheet B.
Thank you.