ExcelBanter - Potential Version Issue with Hlookup

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Potential Version Issue with Hlookup (https://www.excelbanter.com/excel-discussion-misc-queries/237102-potential-version-issue-hlookup.html)

Guerrilla Economics

Potential Version Issue with Hlookup

I am trying to run an Hlookup on a table that includes a TREND variable. The
lookup works fine with numerical data and then returns an N/A for the cells
with the TREND function. This only seems to happen in Excel 2007 and not in
older versions. Has anybody found a workaround for this?

All times are GMT +1. The time now is 09:22 PM.