"Pivotrend" wrote:
whats with the 2 figures at the end of the formula
2 & 0

2 = col_index_num, the 3rd param in the VLOOKUP
(i.e. the col to be returned from the table_array, here, it's the 2nd col,
col B in sheet: BB)

0 = FALSE, the 4th param in the VLOOKUP, i.e. to lookup an exact match
(Typing a zero is just a shorter way to express it, instead of writing
FALSE)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---