Ask Your Question
0

excell hlookup

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

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

Comments

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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

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

Lupp gravatar image

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

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

Stats

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

Seen: 33 times

Last updated: Mar 07 '18