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
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