Vlookup problem, can't recognise...

**zbor** · 03-27-2009, 04:14 AM

I can't figure out why I can't get values in D column, sheet1...

Table array is on sheet4...

(Ignore Error in column E... I just cut data from paste sheet because it was too large)

Also, can't figure why is so huge :-S But that's not problem right now...

Try now

calculator.xlsm

**arthurbr** · 03-27-2009, 04:34 AM

Hi Zbor,
I seem to have problems downloading your file
Could you upload it again please ?

**zbor** · 03-27-2009, 09:18 AM

Solved.. Just need to put *1

**SiliconXu** · 03-27-2009, 10:54 AM

Hi,

Please see attached.

1) the data in Col C is not the same format (it maybe text) as the Col A in the Sheet4. You need to change the text format to number first. I used "--" to change them.

2) the reason why the file is huge because there're too many used ranges (without data but maybe format) in the Sheet "sazetak" and Sheet4.