S
srmyers1
I have a workbook with 2 worksheets, the formula will need to be placed in
worksheet 2. I need to match data from worksheet 1 with data in worksheet 2
and return a value listed on the row in worksheet 1. Here's how it is set
up...
Sheet 1
Column A - Location Code
Column B - Segment
Column C - Post
Sheet 2
Column A - Segment
Column B - post
The "post" columns in the 2 worksheets do not necessarily match. In
worksheet 2 I need to match the segment in worksheet 1, take the "post" in
worksheet 2 and match it 1 to 1, or if the post is +/- .25 from the post
listed in worksheet 1, if it is in that range then I need to return the
location code...
"segment" is set up as a whole number, no decimals, and "post" is a whole
number with 3 decimal places.
worksheet 2. I need to match data from worksheet 1 with data in worksheet 2
and return a value listed on the row in worksheet 1. Here's how it is set
up...
Sheet 1
Column A - Location Code
Column B - Segment
Column C - Post
Sheet 2
Column A - Segment
Column B - post
The "post" columns in the 2 worksheets do not necessarily match. In
worksheet 2 I need to match the segment in worksheet 1, take the "post" in
worksheet 2 and match it 1 to 1, or if the post is +/- .25 from the post
listed in worksheet 1, if it is in that range then I need to return the
location code...
"segment" is set up as a whole number, no decimals, and "post" is a whole
number with 3 decimal places.