Thread: Lookup Value2
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
ltong ltong is offline
external usenet poster
 
Posts: 22
Default Lookup Value2

Hi Max,
Finally, I managed to get the result after reformating the date in
both sheets
Thanks anyway.

Appreciate if you could help me to clear my doubts : -
1) In your formula that contains "&_&" between the cells, eg
$A$2&_&$D$2, is it concatenated both cells. If so, how many cells can
be concatenated in that formula( ie the limitation)?
2)Can we use nested formula within vlookup or Index & Match formula ?
If so, what is the limitation ?
3) what is the difference between the excel formula, Vlookup and Index
& Match ?, In what situation Index & Match formula will apply and not
Vlookup, vice versa and when Index & Match formula will take
precendent over Vlookup ?

Thanks
Regards
Len







"Max" wrote in message ...
The results in E1:E5 (Sheet1) based on the sample data
in the original post should be:

100
9006.3
No match
20
2000

Not sure what happened over there <g,
but if you want a working sample, just drop me a line at either:
demechanik <atyahoo<dotcom, or
xdemechanik <atyahoo<dotcom
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Len" wrote in message
ups.com...
Hi Max,

First of all, thank you for your time to reply.
After several attempts to workaround to understand your formula that
placed in Sheet1 and it seems that the result for E1 to E5 still show
"No match".
Actually, I need the result to be in value that retrieve from column A
in Sheet2.

Rdgs
Len