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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,371
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,332
Messages
5,443,874
Members
405,254
Latest member
lakesidegolfer

This Week's Hot Topics

Top