New Member - Needs Help with Excel IF & V Lookups

[MRV100]

Hi All,

I have a problem where I'm trying to find a formula for the following and don't know if I need to use a V-lookup, an IF statment or something else.

I'm basically trying to say ;

Sheet 1

A B C
1 From To Date
2 J330 J310 10/05/13
3 J330 J310 10/05/13
4 J330 J310 10/05/13


Sheet 2 ( Blank)

A B C
1 From To Date
2
3
4

If J330 is in column A then input cells A2 to C2 from Sheet 1 into Sheet 2 Cell A2-C2

Is the above possible at all & if not what do you recommend would be a close match?

Thank you for taking time out of your day & I appriecate all of your help

 

[ChrisR]

If you want it on a row by row basis, I.e. Row 3 vs. Row 3 then this would work.......

on Sheet 2 cell A3

=IF('Sheet 1'!$A2="J330",'Sheet 1'!B2,"")

You can then copy this across and down.......If this isn't what you are looking for, please post more details.........

An alternative would be to use a vlookup.......