Any alternative for VLOOKUP function

**Tanza** · 04-23-2011, 08:08 AM

Hi,

Is there any alternative formuala for VLOOKUP function which is compatible with older version of Excel (excel 2003)

Thanks and regards,
Tanza

**Marcol** · 04-23-2011, 08:22 AM

Possibly the most useful is

INDEX(array,row_num,column_num)
MATCH(lookup_value, lookup_array, [match_type])

Combined to give
INDEX(array,MATCH(lookup_value, lookup_array, [match_type]),column_num)

Hope this helps

**Palmetto** · 04-23-2011, 08:37 AM

If you give specific details about your objective, we can help provide an exact solution.
Considering uploading a sample workbook that shows what you need.

By pressing Shift + F3 keys, Excel will display the Insert Function dialog, From there, you can use the drop down to select the category of "Lookup & Reference" to show all related functions.

**martindwilson** · 04-23-2011, 09:35 AM

why do you want an alternative? vlookup works ok in all versions anyway

**Tanza** · 04-24-2011, 02:06 PM

Sorry for late response.

I have used the following formula to generate client specific timeline
=VLOOKUP($A$2,Client,2,FALSE)
and to generate future date, applied the below formula
=IF(C2="","",CHOOSE(MATCH(VLOOKUP(A2,Cutomer,3,0),Days,0),VLOOKUP(A2,Cutomer,2,0)+C2,WORKDAY(C2,VLOOKUP(A2, Cutomer,2,0)),EDATE(C2,VLOOKUP(A2, Cutomer,2,0)),EDATE(C2,VLOOKUP(A2, Cutomer,2,0)*12)))

Is it possible to replace the VLOOKUP with INDEX formula.

Thank you
kind regards,
Tanza