SOLVED

Contributor

# Looking up cell and returning values of another cell

Hi.....im look to look up a column and if their any kind of text in it then return what is in another cell.. iv attached below what I'm trying to do... hope use can help.
8 Replies
best response confirmed by Norman_Glenn (Contributor)
Solution

# Re: Looking up cell and returning values of another cell

In D11:

=IF(C11="","",B11)

Fill down.

# Re: Looking up cell and returning values of another cell

Can't belive how easy you made that look.. iv spent hours trying formulas that would only return answers if certain cells were the same text.... thank you very much...

# Re: Looking up cell and returning values of another cell

Hi.. thank you for you help but just looking to see if you can help me out.. iv messed around with the fourmla you gave me to try find another fourmla but not getting any were. just woundering if you can help me again. Using the same attachment I'm trying to look up column C and if its blank then look up column B and if it shows the name/word Paul then in cell D13 values of B13..

# Re: Looking up cell and returning values of another cell

In D11:

=IF(AND(B11="paul",C11=""),B11,"")

Fill down to D16.

# Re: Looking up cell and returning values of another cell

Hi again... iv tried using the fourmla you gave me but its leaving all cells blank. Iv changed it to just do row 13 with =IF(AND(B13="paul",C13=""),B13,"") but its still returning blank. Iv tried switching B13,"") around but this only works if I individually enter the formula and switch the end B13,"") my self

# Re: Looking up cell and returning values of another cell

See screenshot and attached workbook.

# Re: Looking up cell and returning values of another cell

Thank you...I'll have another go at this.. I must be entering something wrong.

# Re: Looking up cell and returning values of another cell

If you still can't get it to work, you might attach a sample workbook demonstrating the problem to a reply.