Lookups across multiple sheets

[Amigo602]

Hi,

I need some help with vlookups.

Here is the current formula I'm using but it doesn't always work:


=IF(ISERROR(VLOOKUP(VLOOKUP(J3,Names!C:J,8),'Live Support'!A:E,4,0)),"",VLOOKUP(VLOOKUP(J3,Names!C:J,8),'Live Support'!A:E,4,0))

J3 is the name Smith, Joe and it is finding that name on the "Names" sheet moving over 8 columns and finding Joe_Smith.

Joe_Smith is then looked up on the "Live Support" sheet and returning a number.

The issues I'm having is that this formula works for some people but not for others. I have even tried naming a range and using that for the table array in the names sheet.

Is there an easier way for me to do this?

Thanks!

Chris

 

[Dave Patton]

- what is the actual range of lookup? Edit ranges as required.
- For an exact lookup, include the final parameter

Possibly
IF(ISERROR(VLOOKUP(VLOOKUP(J3,Names!C1:J1000,8,0),'Live Support'!A1:E1000,4,0)),"",VLOOKUP(VLOOKUP(J3,Names!C1:J1000,8,0),'Live Support'!A1:E1000,4,0))