Put this in C2 (or anywhere you want the lookedup value
=VLOOKUP(A2, 'ER 401k Contributions'!C:BC,53,False)

This look for A2 in column C of ER 401k Contribution and return the value in
that row and column BC.

"Cathy" wrote:

I have a worksheet that I am collecting totals on for each employee.

The worksheet is called ALL Benefits

Then I have several tabs behid it that has the detailed information on it
with a total of the detailed info. I need that total to show up on my All
Benefits tab.

In the example below of the IF function I am using, on the ER 401k
Contributions tab C:C is contains an employee number.

On the All Benefits Tab the A column is where the employee number is.

What I am looking for is ... where ever the employee number is on my ER 401k
Contributions tab, if is matches the number that is number that is in Column
A of the row that contains this formula, the look at what number is in the ER
401 k Contributions column BC and automatically put in that number.

This is the formula I current have .. and it's not working.

=IF('ER 401k Contributions'!C:C='ALL BENEFITS'!A2,'ER 401k Contributions'!BC2)