Messy vlookup..

[ChristopherL]

Hmm, I can't get this function to work... Does it look weird to you?

=IF(ISNA(VLOOKUP(TEXT('Global'!$B$6, "0")&$B$2&D$2&", "&$A5,DeltaRawData!$G:H,2,FALSE)),0,VLOOKUP(TEXT('Global'!$B$6, "0")&$B$2&D$2&", "&$A5,DeltaRawData!$G:H,2,FALSE))

 

[skorpionkz]

could you give us sample data?

 

[Special-K99]

What ya trying to do?
What does "can't get it to function" mean?
Why not explain what you're trying to achieve so we don't have to work it out?