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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

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.
:)
 

Forum statistics

Threads
1,089,165
Messages
5,406,555
Members
403,095
Latest member
cyclingdad

This Week's Hot Topics

Top