I am looking to use a IF formula but not sure how to write it so it returns the value i want.
I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list.
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
I have a list of SKU's that have a location by them, i also have a separate list of locations. I want the If formula to return a value of 1, if the SKU's location appears in my 2nd list.
ID | SKU | Product | Location Type | Current location |
5379 | rxi008 | Black Record Album Frame | High Volume Extra Large | P1-AA003-B |
8814 | wdd004 | Baby Keepsake Box with Drawers | High Volume Extra Large | P3-AA011-A |
16389 | ing005 | 50th Birthday Signature Numbers | High Volume Extra Large | P3-AB013-B |
15997 | ing001 | 18th Birthday Signature Numbers | High Volume Extra Large | #N/A |
940 | fun017 | Inflatable Sumo Suit | High Volume Extra Large | P1-AA027-A |
15998 | ing002 | 21st Birthday Wooden Numbers and Pen | High Volume Extra Large | P2-AA026-C |
18377 | wlw006 | Igloo Hedgehog Home | High Volume Extra Large | P1-AA003-A |
20036 | ing006 | 60th Birthday Signature Number | High Volume Extra Large | P1-AB041-D |
16388 | ing004 | 40th Birthday Wooden Numbers | High Volume Extra Large | #N/A |
15999 | ing003 | 30th Birthday Signature Numbers and Pen | High Volume Extra Large | #N/A |
18387 | luc126 | Scratch Map Deluxe Edition | High Volume Extra Large | P2-AA005-B |
<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>