HLookUp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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..
 
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.
 
Back
Top