The Punters Lounge - The World's Best Betting Forum - View Single Post

GotaFancy? · 20-10-2006, 19:42

VLOOKUP (Vertical lookup) looks up a value from within a list.

So VLOOKUP(A2,Sheet2!$A$1:$A$1001,1,FALSE)

says to find the value in cell A2 from within the list in the range A1 to A1001, returning the first column (which is itself - column 2 or larger would return something different, according to the range it is looking up from). The FALSE on the end just tells it to find the exact value (and not the "nearest" value).

ISERROR(blahblah) basically asks the question, is "blahblah" correct or do we have an error. It returns either TRUE or FALSE. So with the example of the VLOOKUP, if it cannot find the value it will return an error (#N/A), if it can find the value, it returns the name of the horse.

So the statement is (in english) If the horse we're looking for is not in the list (an error is returned) then display nothing ("") otherwise display "Yes".

Generally I find the Excel help very good - it will probably explaing ISERROR and VLOOKUP far clearer than I have done :ok

20-10-2006, 19:42	#8 (permalink)
GotaFancy? God Punter Join Date: 18 Jun 2005 Posts: 34,043 Awards Showcase Total Awards: 4	Re: Microsoft Excel help VLOOKUP (Vertical lookup) looks up a value from within a list. So VLOOKUP(A2,Sheet2!$A$1:$A$1001,1,FALSE) says to find the value in cell A2 from within the list in the range A1 to A1001, returning the first column (which is itself - column 2 or larger would return something different, according to the range it is looking up from). The FALSE on the end just tells it to find the exact value (and not the "nearest" value). ISERROR(blahblah) basically asks the question, is "blahblah" correct or do we have an error. It returns either TRUE or FALSE. So with the example of the VLOOKUP, if it cannot find the value it will return an error (#N/A), if it can find the value, it returns the name of the horse. So the statement is (in english) If the horse we're looking for is not in the list (an error is returned) then display nothing ("") otherwise display "Yes". Generally I find the Excel help very good - it will probably explaing ISERROR and VLOOKUP far clearer than I have done :ok