find contents of one sheet and displaying on another based on contents

oldpup223

Board Regular
Joined
Jul 31, 2012
Messages
83
I am trying to retrieve contents of a cell in another sheet based on the contents of that sheets adjoining column as I want to find the data in sheet (ABC) based on the contents of sheet (ABC') column (C) if c1= U then display contents in cell (a1) in sheet(ABC) to sheet (DEF) (K14). I need it to work on both text and numbers.
I have tried the =if and the =then but cannot get the syntax corrected
Thank you
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

oldpup223

Board Regular
Joined
Jul 31, 2012
Messages
83
you have made that so simple I am flabbergasted I have wasted over an hour trying to get that so I do thank you so very much for your reply and expertise.
:)
 

Watch MrExcel Video

Forum statistics

Threads
1,089,942
Messages
5,411,411
Members
403,368
Latest member
Cyril18

This Week's Hot Topics

Top