Aces High Bulletin Board

General Forums => The O' Club => Topic started by: SFRT - Frenchy on November 17, 2006, 12:30:35 PM

Title: Xcell gurus
Post by: SFRT - Frenchy 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

Title: Xcell gurus
Post by: Aqualung 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.

Title: Xcell gurus
Post by: SFRT - Frenchy on November 17, 2006, 05:54:09 PM

Thank you. What does "" means?