Need help with lookup formula

[Phyllis]

Hi,

On sheet1, I have the following columns:

A B C D
Ck No Date EE No. Amt

On sheet2 I have the following columns

A B C D E F
EE No. Last First Address City Zip
Name Name

I want find on sheet2 any ee nos matching in Sheet1 and if
there is a match, input the name and addresses from Sheet
2 in cells e,f,g,h & i of sheet 1.

I hope this make sense.

 

[Frank Kabel]

Hi
try the following in E2 on sheet1
=IF(COUNTIF('sheet2'!$A$1:$A$100,C2),VLOOKUP(C2,'sheet2'!$A$1:$F$100,2,
0),"")
and copy this down.
Adapt the column index in the VLOOKUP formula for your other columns
accordingly

 

[Jason Morin]

Insert this in to E2 on Sheet1, fill across and then down:

=VLOOKUP($C2,Sheet2!$A:$F,COLUMN()-3,0)

HTH
Jason
Atlanta, GA

 

[Alan Beban]

Or array enter the following into E2:I2 and fill down:

=VLOOKUP($C2,Sheet2!$A:$F,{2,3,4,5,6},0)

Alan Beban