VLOOKUP/MATCH with Ranges

  • Thread starter Thread starter Rudy
  • Start date Start date
R

Rudy

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

Rudy
 
Thank you, Rudy
GDC

Rudy said:
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


.
Click to expand...
Click to expand...
 
Back
Top