If/then function - Help!

mirandork

New Member
Joined
Jun 1, 2018
Messages
4
Hi all,

I need some help figuring out a formula to read two columns and if they're both filled, then to provide the data.

Example:

I have one worksheet that serves as my data dump. Column C is a list of customers and column J and K are the brands of computers and smartphones they own. Sometimes column J and K will be blank.

In a second worksheet I'm trying to write a formula that will read the data dump worksheet, provide the customer name, the brand of smartphone and/or computer only IF J and/or K are filled out.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Assuming the data are in Sheet1 and in the other sheet the customer names are in column A beginning in A2, try

Formula in B2 copied across to C2 and down
=IFERROR(INDEX(Sheet1!J:J,MATCH($A2,Sheet1!$C:$C,0))&"","Not found")

Hope this helps

M.
 
Upvote 0

Forum statistics

Threads
1,213,479
Messages
6,113,897
Members
448,530
Latest member
yatong2008

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