Looking for an If formula

Oakey

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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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)
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,268
Members
448,558
Latest member
aivin

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
Back
Top