Excel 2010 - IF=, THEN... for COLUMNS

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ldweisberg

Thread Starter
Joined
Jan 20, 2011
Messages
3
I'm using Excel 2010.
I have a workbook with TWO Tabs (sorry, cannot attach).
First Tab, the data - Second Tab, the form I want generated.

In the first Tab, Column A is a date. Columns B and C are TEXT Data
For the second tab, I want to create formula that reads like this:

If first tab Column A = a specified date, then bring in the information in first Columns B and C.

If the date appears five times, can it bring the information in and create five rows? (or am I restricted to only cell to cell formulas?)


It sounds like I should just do a simple cut/paste sort of thing and not create a difficult formula, but I really need a formula, because ultimately it will be expanded beyond two simple tabs.
 

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Hi, welcome to the board.

One thing is not clear, a form in the second tab? Form? Not a table.

You could just extract Column A B C for the the Fisrt Tab and put this in a new workbook to attach so that you can expplain it better.
I know, when I explain somehting I cannot understand why the other person doesn't understand it but that's the whole thing, to get the picture right.
 

ldweisberg

Thread Starter
Joined
Jan 20, 2011
Messages
3
OK - attached is a document. For the specifics, I want a vlookup or formula on the Dailies Tab the would return information from the sq5101 Tab.

If the information in Column F on "sq5101" matches A1 on "Dailies", I want the information in Column A and Column C from "sq5101" to show up on "Dailies".

Therefore in my sample, on Dailies, I should see:

A3=s0030
B3=Bob
A4=s0050
B4=Jim

This is based on the date on A1 of the "Dailies" Tab A1 matching the date in Column F on "sq5101" Tab
 

Attachments

Keebellah

Hans
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,612
Okay, I've downloaded the file and will see what I can do.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top