Hlookup err.502

[mdriden]

I have searched the internet and this forum for an answer but I am coming up clueless.
I have a spread sheet with customer names in column A
Addresses are in Column B

I have a cell with a drop down that shows all of the names in column A and if I do an HLOOKUP in the cell beside it I keep getting an Err.502

Here is the formula:
=HLOOKUP(D29,$A:$B,B:B,1)
D29 is the customer name
$A:$B is the table where the customer names and addresses are located
B:B is the column that holds the address
1 - I have tried both false and true values with no luck.
This works perfect on an excel spread sheet but not with libre office.

Any suggestions?

Thanks in advance

[erAck]

@mdriden

This works perfect on an excel spread sheet

I doubt that.

[Villeroy]

@mdriden

=HLOOKUP(D29,$A:$B,B:B,1)

=VLOOKUP(D29;$A:$B;2;0)

[mdriden]

@Villeroy

=VLOOKUP(D29;$A:$B;2;0)

Thanks,
Not sure why it worked in Excel but needed this in Libreoffice.
spreadsheet has the exact same layout.

[Villeroy]

I’m 100% sure that this can not work in any spreadsheet program. Since 30 years LOOKUP, VLOOKUP and HLOOKUP are the same functions in all popular spreadsheets.