VLOOKUP/MATCH with Ranges

[Rudy]

Sounds like your cell format is set to Text. Change the
format to General and you should see the results.

Rudy

 

[Gilbert De Ceulaer]

Thank you, Rudy
GDC

Sounds like your cell format is set to Text. Change the
format to General and you should see the results.

Rudy

-----Original Message-----
This works :
=+VLOOKUP(E$48;HUURDERS.xls!db;MATCH($C49;[HUURDERS.xls] huurders!$B$3:$AZ$3;
0))
Why doesn't
=+VLOOKUP(E$48;HUURDERS.xls!db;MATCH($C49;[HUURDERS.xls] huurders!$B$3:$BC$3;
0))
work ? (It just gives the text of the formula)
although it gives the right result in the formula-wizard !

And when I retype the "AZ", it continues to give me the text instead of the
result.

The same thing happens with
MATCH($C49;[HUURDERS.xls]huurders!$B$3:$AZ$3;0)

The final goal is to make the formula
=+VLOOKUP(E$48;HUURDERS.xls!db;MATCH($C49;HUURDERS.xls! titels;0))
work, where "titels" are the labels of the db-range.

Can somebody help me ?

Gilbert


.