Ask Your Question

excell hlookup

asked 2018-03-07 22:04:05 +0200

ooo gravatar image

I have multiple criteria and multiple sheets using =hlookup{N4&N5&A16,$2018TFSA.$A$11:$A$99&$2018TFSA.$D$11:$D$99&$2018TFSA.$E$11:$E$99,14,0}

This returns a error 512 - can anyone help ? many thanks in advance.

edit retag flag offensive close merge delete


Please give a specific example of the criteria and desired results. Also, the title and tags are not good. This is not an MS Office forum. Are you asking about LibreOffice Calc? See guidelines for asking.

Jim K gravatar imageJim K ( 2018-03-08 01:46:14 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-03-07 22:57:17 +0200

Lupp gravatar image

updated 2018-03-07 23:00:30 +0200

You used curly brackets where ordinary parentheses are needed.
The culy brackets around formulas enclose everything (including the =) and must not be entered, but are generated for display when the formula is entered for array-evaluation by Ctrl+Shift+Enter.

And you cannot do a horizontal lookup in a vertical array.

Where did you get that flim-flam from?

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-07 22:04:05 +0200

Seen: 35 times

Last updated: Mar 07 '18