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

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

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.
 

Forum statistics

Threads
1,089,667
Messages
5,409,626
Members
403,272
Latest member
Karl Matacz

This Week's Hot Topics

Top