« previous next »
Pages: [1]   Go Down

Author Topic: Xcell gurus  (Read 175 times)

Offline SFRT - Frenchy

  • Platinum Member
  • ******
  • Posts: 5420
      • http://home.CFL.rr.com/rauns/menu.htm
Xcell gurus
« on: November 17, 2006, 12:30:35 PM »
What does those formulas mean?

=IF(C26<100,"",(IF(C26<2100,VLOOKUP(C26,D36:F53,3,TRUE),VLOOKUP(C26,H33:I54,2,TRUE))))

and

=IF(E6=""."",ROUND(VLOOKUP(E6,K48:Q51,5,FALSE),0))

I do have the basic idea, but I'm a bit confused with the D36:F53,3,TRUE thingy. Would someone translate those formulas in English, so I can build a similar data table?

Thx

:D
Logged
Dat jugs bro.

Terror flieger since 1941.
------------------------

Offline Aqualung

  • Zinc Member
  • *
  • Posts: 35
Xcell gurus
« Reply #1 on: November 17, 2006, 12:40:15 PM »
That's an Excel spreadsheet macro.  C26,D36:F53,3,TRUE are parameters in the function VLOOKUP().  C26 is the lookup value, D36:F53 is the range to look in, 3 is the column index where the results will be put, and TRUE represents if VLOOKUP is to do an exact or approximate match.  More information about VLOOKUP can be found using Excel's help.
Logged

Offline SFRT - Frenchy

  • Platinum Member
  • ******
  • Posts: 5420
      • http://home.CFL.rr.com/rauns/menu.htm
Xcell gurus
« Reply #2 on: November 17, 2006, 05:54:09 PM »
Thank you. What does "" means?
Logged
Dat jugs bro.

Terror flieger since 1941.
------------------------
Pages: [1]   Go Up
« previous next »