ExcelBanter - HLookUp

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - HLookUp (https://www.excelbanter.com/excel-worksheet-functions/155633-hlookup.html)

Help!

I can get a simple HLookup fundtion working.. see example below: (table and
the Hlookup formula extracts the number 0.65
Counter GIL SYNF FRC
0.65 1.63 1.85

GIL 0.65

Problem: When I use the same formula for a table linked to bloomberg, I get
a #N/A response. Bloomberg problem? Or the HLookup formula works for hard
entry and not cells with formula..

--
David

Maybe the cell with the formula also has space characters, so an exact
match isn't found. If that's the problem, you could include the TRIM
function in that formula, to remove the leading and trailing spaces.

David Mok wrote:
Help!

I can get a simple HLookup fundtion working.. see example below: (table and
the Hlookup formula extracts the number 0.65
Counter GIL SYNF FRC
0.65 1.63 1.85

GIL 0.65

Problem: When I use the same formula for a table linked to bloomberg, I get
a #N/A response. Bloomberg problem? Or the HLookup formula works for hard
entry and not cells with formula..

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html