Need help with lookup formula

  • Thread starter Thread starter Phyllis
  • Start date Start date
P

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.
 
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
 
Insert this in to E2 on Sheet1, fill across and then down:

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

HTH
Jason
Atlanta, GA
 
Or array enter the following into E2:I2 and fill down:

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

Alan Beban
 
Back
Top