If Cell contains text, return that text and then perform another if and statement?

**gachogavacho** · 08-28-2013, 03:42 PM

How can I achieve the following:

If Cell B2 contains text, display that text in cell A14 AND then do the following:

If any of the cells in the range A2 to A11 contain "Victor", and there is a number in the cell in the next column to the right (column B), then return that number into A15

**Miraun** · 08-28-2013, 03:46 PM

In A14:
=IF(Istext(B2),B2,"")

In A15:
=IFERROR(VLOOKUP("Victor",A2:B11,2,FALSE),"")

**gachogavacho** · 08-28-2013, 05:05 PM

This is working much better! Thank you.

I'm getting closer to what I'm trying to achieve!

What I have is a weekly tracker that shows, weekly data, broken down by customer and what contractor served them, but the names can change, so I have a validation drop down list of names to choose from. How can I make it so excel will populate the customer name and amounts to pay each contractor when I put data? on the days they work?

I attached this workbook that has an example of what the data should look like, but there are no formulas. Book1.xlsx
The color data on the right will fill an entire workbook for a week of work up to 6 people. I'm hoping it's possible to fill this data in and have excel generate the totals for each contractor individually. Is this possible?

**FDibbins** · 08-28-2013, 05:13 PM

Because there are no formulas, its hard to make out where the values come from - and why. Could you show (maybe with arrows - and some text) how you arrive at the answers you have?

**gachogavacho** · 08-28-2013, 05:15 PM

The problem is, for me, If I enter a customer name, I only want the data for each contractor to enter if their name exists in the first column and there is an amount for them in the column on the right.

**gachogavacho** · 08-28-2013, 05:46 PM

Originally Posted by FDibbins

Because there are no formulas, its hard to make out where the values come from - and why. Could you show (maybe with arrows - and some text) how you arrive at the answers you have?

Thank you for your answer! I didn't enter any formulas into this sheet to simplify getting to the end result

I am re-uploading with arrows and text to show the process of what data is entered and what should happen as it is entered to better understand what formulas to use. Let me know what other info I can give if you need it. I envy you guys for knowing this stuff!
Book1.xlsx

**gachogavacho** · 08-28-2013, 10:50 PM

I hope i'm asking the right questions?

If Cell contains text, return that text and then perform another if and statement?

LinkBack

Thread Tools

Rate This Thread

Display

If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Re: If Cell contains text, return that text and then perform another if and statement?

Thread Information

Users Browsing this Thread

Similar Threads

If cell contains certain text and certain text then return predefined text

[SOLVED] If Or statement to check cell text and delete entire row if text is found

[SOLVED] Find partial text string within another text string return original text into cell.

If cell contains text1, text2 or text 3 return this text, otherwise return X

Can a cell contain text and perform calculation?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions