vlookup- approximate match

[drewbny]

I tried using vlookup with approximate match and my vlookups werent working. I have to lookup a column which is a concatenate of two other columns. does vlookups on approximate match not work with concatenates?

 

[drewbny]

Hi Aladin, my current formula is

=IF($AT$4>0,LOOKUP(bignum,CHOOSE({1,2},0,INDEX(projsls,(MATCH($B29,Prjsheet,0))))/1000),LOOKUP(bignum,CHOOSE({1,2},0,INDEX(ladder20,(MATCH($L29,Ladders,0))))))

In order to make this formula calculate faster, should I replace the Index match formula with the Lookup formula with the format shown below? I need an exact match.

=IF(LOOKUP(A2,$E$2:$E$400)=A2,LOOKUP(A2,$E$2:$E$400,$G$2:$G$400),"")

 

[Aladin Akyurek]

Hi Aladin, my current formula is

=IF($AT$4>0,LOOKUP(bignum,CHOOSE({1,2},0,INDEX(projsls,(MATCH($B29,Prjsheet,0))))/1000),LOOKUP(bignum,CHOOSE({1,2},0,INDEX(ladder20,(MATCH($L29,Ladders,0))))))

In order to make this formula calculate faster, should I replace the Index match formula with the Lookup formula with the format shown below? I need an exact match.

=IF(LOOKUP(A2,$E$2:$E$400)=A2,LOOKUP(A2,$E$2:$E$400,$G$2:$G$400),"")

That is only possible if E2:E400 is in ascending order...