Looking for an If formula

[Oakey]

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.

[TABLE="width: 629"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]SKU[/TD]
[TD]Product[/TD]
[TD]Location Type[/TD]
[TD]Current location[/TD]
[/TR]
[TR]
[TD="align: right"]5379[/TD]
[TD]rxi008[/TD]
[TD]Black Record Album Frame[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P1-AA003-B[/TD]
[/TR]
[TR]
[TD="align: right"]8814[/TD]
[TD]wdd004[/TD]
[TD]Baby Keepsake Box with Drawers[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P3-AA011-A[/TD]
[/TR]
[TR]
[TD="align: right"]16389[/TD]
[TD]ing005[/TD]
[TD]50th Birthday Signature Numbers[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P3-AB013-B[/TD]
[/TR]
[TR]
[TD="align: right"]15997[/TD]
[TD]ing001[/TD]
[TD]18th Birthday Signature Numbers[/TD]
[TD]High Volume Extra Large[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]940[/TD]
[TD]fun017[/TD]
[TD]Inflatable Sumo Suit[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P1-AA027-A[/TD]
[/TR]
[TR]
[TD="align: right"]15998[/TD]
[TD]ing002[/TD]
[TD]21st Birthday Wooden Numbers and Pen[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P2-AA026-C[/TD]
[/TR]
[TR]
[TD="align: right"]18377[/TD]
[TD]wlw006[/TD]
[TD]Igloo Hedgehog Home[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P1-AA003-A[/TD]
[/TR]
[TR]
[TD="align: right"]20036[/TD]
[TD]ing006[/TD]
[TD]60th Birthday Signature Number[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P1-AB041-D[/TD]
[/TR]
[TR]
[TD="align: right"]16388[/TD]
[TD]ing004[/TD]
[TD]40th Birthday Wooden Numbers[/TD]
[TD]High Volume Extra Large[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]15999[/TD]
[TD]ing003[/TD]
[TD]30th Birthday Signature Numbers and Pen[/TD]
[TD]High Volume Extra Large[/TD]
[TD="align: center"]#N/A[/TD]
[/TR]
[TR]
[TD="align: right"]18387[/TD]
[TD]luc126[/TD]
[TD]Scratch Map Deluxe Edition[/TD]
[TD]High Volume Extra Large[/TD]
[TD]P2-AA005-B[/TD]
[/TR]
</tbody>[/TABLE]

 

[tyija1995]

Hey,

Try something like this:

F2:
=IF(COUNTIF(Input_Your_Locations_List_Range_Here, E2)>0, 1, "")

Where E2 is the first "Current Location" value - change the locations list range to wherever that is to reference it. Then drag formula down the F column (Assuming data is in Cols A-E, change appropriately)

 

[Oakey]

That worked, thank you