Sir,
with refer to the above subject I want Vlookup Value return first cells only against multiple reference and column.
am using this formula value return is perfect when data without duplication. if data duplication value return is multiple time as same value.
=VLOOKUP($A2&B2&C2,CHOOSE({1,2,3},Data!$A$2:$A$11&Data!$B$2:$B$11&Data!$C$2:$C$11,Data!$D$2:$D$11),2,0)
file attached. please help me.
See attached: formulas entered with Ctrl+Shift+Enter
with a helpcolumn.
I don't get the same result (see the red cells) since the date are not equal.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
The VLOOKUP ignores column D (CHOOSE only looks at A, B and C).
JohnTopley
lookup value return perfect you are rocking.
Thanks you so much sir. sorry for the late reply.
as requested to you sir if you get time please explain the formulas and specifically how is it working array formula in excel.
oeldere sir,
first 3 column only i have consider lookup range.
thank you so much sir for your replay.
Then the amend file.
you have to explain why cell F10 is blanc instead of a zero .
Sir,
data not available in master data(sheet 2 name is Data)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks