VLOOKUP or IF/OR Function

[Kiwi den]

Below is a diagram of sheet 1 ( reference sheet) and sheet 2, I would like to have info on sheet 2 to only show if column H from sheet 1 is AA, not sure is a vlookup or if/or formula is best, any help much appreciated
Sheet 1
. A B C E F G H
1 BL CD RF WW ZZ AA
3 QI PP LY MN FG DD CE
4 SD JH II YR ES VO AA


Sheet 2
. A B C E F G H
1 BL CD RF WW ZZ AA
3
4 SD JH II YR ES VO AA

Sheet 2: If H1 =AA, then, A1 =BL, B1=CD, C1=RF, E1=WW, F1 shows nothing, G1=ZZ
<strike></strike>

 

[jtakw]

Hi,

If F1 shows nothing, why is there a value (ES) in Row 4 in Sheet 2?

 

[Kiwi den]

im trying to edit it to more reflect what I want, but am waiting admin approval

. .A ...B .C...D.. ..E ...F ….G.... H
1 BL CD RF .WW ZZ JK,,……...AA
3 QI .PP LY .MN .FG DD.. JJ.. CE
4 SD JH. II .YR. ES. VO ...LJ...AA


Sheet 2
. ..A.... B... C.. D....E.. F.. G.. H
1 .BL .CD .RF .WW ZZ .JK......AA

3
4.SD. JH.. II.. YR.. ES. VO..LJ.. AA​

 

[jtakw]

You could've just explained it in your reply?

 

[jtakw]

Ok, it's unclear what values are in which column, may be this.

Change Sheet154 in my formula to match your Sheet 2 name, formula in A1 copied down and across to Column H:

Book1
	A	B	C	D	E	F	G	H
1	BL	CD	RF	WW	ZZ	JK		AA
2	QI	PP	LY	MN	FG	DD	JJ	CE
3	SD	JH	II	YR	ES	VO	LJ	AA
Sheet154

Book1
	A	B	C	D	E	F	G	H
1	BL	CD	RF	WW	ZZ	JK		AA
2
3	SD	JH	II	YR	ES	VO	LJ	AA
Sheet164

Cell Formulas
Range	Formula
A1	=IF(AND(Sheet154!$H1="AA",Sheet154!A1<>""),Sheet154!A1,"")

 

[Kiwi den]

sorry cannot get that formula to work

 

[jtakw]

sorry cannot get that formula to work

If you want further help, you'll need to explain what you mean.

 

[Kiwi den]

I have copied the formula and pasted it into the cells, all it shows me is the formula, it dies not actually perform the formula

 

[Kiwi den]

Sorry figured it out office 365 Excel requires all , to be ;

Thank you​

 

[jtakw]

Sounds like your formula cell is formatted as Text.

Select formula cell, right click, format cells, select General, OK.

Re-enter the formula.

Also check to make sure you have "Calculations" on automatic.

EDIT: just saw your last post, glad you got it working, I believe the ; as opposed to , is due to regional settings rather than Office 365...