Hi
I'm trying to fill the PRICE to Col G, from the table in Col A-C,
by PART# and closest QUANTITY.
Example:
Row3 - X1 700 PRICE in Col G Should be 2.6 --> ABS(500-700) = 200 | ABS(1000-700) = 300
1111.JPG
I tried to use the INDEX and MATCH functions
Tried to take into account the PART# in several ways but couldn't get the right results.Please Login or Register to view this content.
I'll be glad to receive your help.
Bookmarks