Same formula, different result.

[TrainGirl]

I have a lookup formula that we use to lookup monthly sales everyday from an automated spreadsheet:

=IF(ISNA(VLOOKUP($B7,'1'!$A$2:$AS$100,20,FALSE)),0,VLOOKUP($B7,'1'!$A$2:$AS$100,20,FALSE))

So essentially look up the employee name (B7) in Woorksheet named '1' rang A2:A100, row 20 (if no data enter 0)

I want to use the same formula, too look up calls per employee based on a different worksheet, but still the same idea:

=IF(ISNA(VLOOKUP($C7,CALLS!$A$2:$AS$100,4,FALSE)),0,VLOOKUP($C7,CALLS!$A$2:$AS$100,4,FALSE))

So essentially the same formula, looking look up employee name from (C7) (different name format) in worksheet 'CALLS' range from A2:A100, row 4 (if no data enter 0)

So it should work the same right? NO. It is not working, essentially what I can figure out is for some reason it can't find the employee name, even if I change the name, the format make sure they match etc.

I have tested it is looking for the information in the right worksheet, just not finding the employees name??

I've been on this for 2 days!!! Does someone see my mistake?

Thanks,

[Speshul]

=IF(ISNA(VLOOKUP($C7,CALLS!$A$2:$AS$100,4,FALSE)),0,VLOOKUP($C7,CALLS!$A$2:$AS$100,4,FALSE))



Are you sure the value in C7 is somewhere within CALLS!A2:A100? A lookup_value has to be found in the LEFTMOST column (column 1) of the range you provide. So C7 must be present in column A of the CALLS table or it will error

[TrainGirl]

BINGO!!

Thank you!!!

[Speshul]

Sometimes a second set of eyes is all you need