I tried HLOOKUP within the sheetnode and it works well. But when I tried it to a cell referencing another sheetnode it displays #N/A using this function:

='Schedule'!HLOOKUP('text',G5:J6,2,0)

I also tried another function like CHOOSE and it works well both in the same and another sheetnode.

='Schedule'!CHOOSE(1,A5,A8)

I want to know if HLOOKUP does not work in another node or maybe there is something that I should do. Please let me know. Any answers will be helpful.

Comments

infojunkie’s picture

infojunkie
Location Vancouver
commented
Category: task » support

Thanks for the report. I will investigate this.

andsfestin’s picture

andsfestin commented

Thanks infojunkie for acknowledging this post. I knew that choose and hlookup have different function format so I tried this one:

=HLOOKUP("text",'Schedule'!G5:J6,2,0)

This works. The node referred 'Schedule' counts as a parameter of the function.

infojunkie’s picture

infojunkie
Location Vancouver
commented

In your opinion, should the other syntax work as well? Does it work in Excel/LibreOffice Calc?

infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Closed (fixed)

No reply from OP.