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
 

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,078,137
Messages
5,338,458
Members
399,234
Latest member
WaddoAU

Some videos you may like

This Week's Hot Topics

Top