Reply to thread

Message

[QUOTE="Duncan, post: 7412159"]
Claus, many thanks for the speedy reply.  I don't mean to be a pain, but could you assist in explaining what you just did there!

=VLOOKUP(LOOKUP(9^9,1*LEFT($J3,COLUMN(1:1))),MASTER_FEES,2,0)
The 'LOOKUP' itself, LOOKUP(9^9,1*LEFT($J3,COLUMN(1:1))).  If I'm reading it right, it is looking up the value '9^9' in the lookup vector '1*LEFT($J3,COLUMN(1:1))'.  What does the '9^9' signify?  To me it looks like 9*9*9*9*9*9*9*9*9, but it can't be.  This value doesn't exist in the spreadsheet!  Where / what are you getting it from?

The Lookup Vector of '1*LEFT($J3,COLUMN(1:1))', to me reads as: get the leftmost 'COLUMN(1:1)' characters from the value in the cell $J3.  When I evaluate 'COLUMN(1:1)', it always returns '1'.  So, it now says, "return the 1*1 characters from the left of the contents of cell $J3."

From my reading, we now have:

VLOOKUP(LOOKUP(387420489,1*1),MASTER_FEES,2,0)

I don't understand what the formula is trying to do?  I could just say thanks for that and move on, however I'd really like to know what it's doing.

Duncan
[/QUOTE]

Verification