Excel help?

Question

What excel formula will i use aside from vlookup? it's quite complicated...

Answer 1

Use MATCH

Enjoy my profile, I am the VBAXLMan

Answer 2

There are lots of comparable functions. I use LOOKUP, MATCH and INDEX quite regularily. There are many others. Take time to read the help on these lookup and reference functions:

ADDRESS Returns a reference as text to a single cell in a worksheet

AREAS Returns the number of areas in a reference

CHOOSE Chooses a value from a list of values

COLUMN Returns the column number of a reference

COLUMNS Returns the number of columns in a reference

HLOOKUP Looks in the top row of an array and returns the value of the indicated cell

HYPERLINK Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet

INDEX Uses an index to choose a value from a reference or array

INDIRECT Returns a reference indicated by a text value

LOOKUP Looks up values in a vector or array

MATCH Looks up values in a reference or array

OFFSET Returns a reference offset from a given reference

ROW Returns the row number of a reference

ROWS Returns the number of rows in a reference

TRANSPOSE Returns the transpose of an array

VLOOKUP Looks in the first column of an array and moves across the row to return the value of a cell

Hope this helps,
Kind Regards,
QwertyKPH @ Yahoo

Answer 3

Depends on what you want to do.