Forum Discussion

Brass Contributor

Mar 10, 2022

Solved

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.

Return-To-other-cell.xlsx9 KB

excel

Formulas and Functions

office 365

HansVogelaar
Mar 10, 2022
Norman_Glenn

In D11:

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

Fill down.

8 Replies

HansVogelaar
MVP
Mar 10, 2022
Norman_Glenn

In D11:

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

Fill down.
- Norman_Glenn
  Brass Contributor
  Mar 14, 2022
  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..
  - HansVogelaar
    MVP
    Mar 14, 2022
    Norman_Glenn
    
    In D11:
    
    =IF(AND(B11="paul",C11=""),B11,"")
    
    Fill down to D16.
- Norman_Glenn
  Brass Contributor
  Mar 11, 2022
  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...