Vlook up

Sue van Niekerk

Hi All I am trying do V look up in this sheet - so that Last hazard reported - we want to pull the LAST date reported - I have the vlookup working BUT it pulls the first date note the last date

Stefan

Hi @Sue van Niekerk,

without seeing neither the source sheet as a whole nor your formula, I guess it's maybe only the wrong column count in the VLOOKUP?

Hope this helps

Stefan

Sue van Niekerk

Hi Stefan

Here is my formula so far =VLOOKUP(Name@row, {Master Hazards and Near Misses Range 1}, 2, false) - but this returns the first date the name appears instead of the last date

Stefan

Hi @Sue van Niekerk,

in your case I recommend using the a combination of MAX and COLLECT

https://help.smartsheet.com/function/max :

=MAX(COLLECT({cross sheet reference to the column with DATE}, {cross sheet reference to the column with NAME}, Name@row))

Hope this helps

Stefan

Sue van Niekerk

AWESOME!! worked thank you so much

Stefan

@Sue van Niekerk

Pleasure :-)

Stefan