Wow..
Vlookup is way too dodgy!
Index match returns the values looking up itmes in a column, but vlookup which should have had exact matches had issues with - in the names and came with with incorrect values....
=INDEX('Sheet2!C:E,MATCH(AG974,'Sheet2!C:C,0),3)
This checks for a match to cell AG974 in the other worksheet - 'Sheet2' and gets the value in column E...(The 3rd column in the columns selected)
Regards,
Tom Bizannes
Excel Macros and Development Sydney
Monday, January 05, 2009
Subscribe to:
Posts (Atom)
