Looking for an If formula

Oakey

New Member
Joined
Jan 9, 2017
Messages
39
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.

IDSKUProductLocation TypeCurrent location
5379rxi008Black Record Album FrameHigh Volume Extra LargeP1-AA003-B
8814wdd004Baby Keepsake Box with DrawersHigh Volume Extra LargeP3-AA011-A
16389ing00550th Birthday Signature NumbersHigh Volume Extra LargeP3-AB013-B
15997ing00118th Birthday Signature NumbersHigh Volume Extra Large#N/A
940fun017Inflatable Sumo SuitHigh Volume Extra LargeP1-AA027-A
15998ing00221st Birthday Wooden Numbers and PenHigh Volume Extra LargeP2-AA026-C
18377wlw006Igloo Hedgehog HomeHigh Volume Extra LargeP1-AA003-A
20036ing00660th Birthday Signature NumberHigh Volume Extra LargeP1-AB041-D
16388ing00440th Birthday Wooden NumbersHigh Volume Extra Large#N/A
15999ing00330th Birthday Signature Numbers and PenHigh Volume Extra Large#N/A
18387luc126Scratch Map Deluxe EditionHigh Volume Extra LargeP2-AA005-B

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

tyija1995

Well-known Member
Joined
Feb 26, 2019
Messages
780
Office Version
  1. 365
Platform
  1. Windows
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)
 

Watch MrExcel Video

Forum statistics

Threads
1,129,316
Messages
5,635,521
Members
416,862
Latest member
MGDlite

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top