Vlookup function

[0o0]

Hi,
I've just starting learning some of the basic excel functions, in my spreadsheet the vlookup function works fine up a point then it displays N/A, is there a limit to how many columns the function can process or is my formula incorrect?
=VLOOKUP(G3,B171,3,FALSE) - works
=VLOOKUP(G3,B1:D72,3,FALSE) - returns N/A
File is attached (couldn't upload the .xlsx so i zipped it)

Thanks

 

[scottgorilla]

When I looked at your formula you are asking it to lookup the max rain flow which is in cell c74 but you limited the search area through d72

G4 equals =MAX(rain_flow)

change either the number of rows it can look in or what it is looking for must fall within the lookup area.



Good Luck,



Scottgorilla