ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/139870-vlookup.html)

Sena

VLOOKUP

if the table column that is being used for column index contains formuales
the vlookup results in an error message unless that column is paste special
with values. Is there any way to overcome this ?

Thanks
--
Cheers !

Toppers

VLOOKUP

Om my testing VLOOKUP worked OK with your scenario (unless I misunderstand)

Can you give an example of the problem, with the various formulae?

"Sena" wrote:

if the table column that is being used for column index contains formuales
the vlookup results in an error message unless that column is paste special
with values. Is there any way to overcome this ?

Thanks
--
Cheers !

All times are GMT +1. The time now is 07:16 AM.