• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Fetching value from the left getting wrong information

A

ananthram

New Member
Hi all,


I am using below formula to lookup value which is in left column of Sheet1 but this is fetching the 1st value and the second repeated lookup_value is showing the 1st value which is in main source data. Please help me with this.


Code: 
=INDEX(Sheet1!$A$2:$A$27,MATCH(Sheet2!A1,Sheet2!$A$1:$A$26,0))
 
Hi Ananthram..


You are searching a "Data", from same area.. in the same sheet.. and want to return.. the data from another sheet.. same area + 1.. How..


Just a guess.. try the below..

=INDEX(Sheet1!$A$2:$A$27,MATCH(Sheet2!A1,Sheet1!$A$1:$A$27,0))


apply the formula in Sheet 2.. Column B..


Regards,

Deb
 
Hi,


Under which column you want the output please specify the column number


Ex:=INDEX(Sheet1!$A$1:$A$27,MATCH(Sheet2!A1,Sheet2!$A$1:$A$27,0),4)

Thanks,

Suresh Kumar S
 
Hi Suresh please check the below file for the data and the function which i have used


https://www.box.com/files/0/f/0/1/f_5881131663
 
Hi,


I got the error message

The item you are trying to access has either been deleted or is unavailable to you


Thanks,

Suresh Kumar S
 
Try this 1 Suresh


https://dl.boxcloud.com/bc/1/074eedf6b15ba9537be895a33d585248/JolueqOGpciD6dgYhecNBoVpYxkvmYe1ZLheZor6BF4DUBIelMQTkFwYIys3nIibNIIEHUp447tBZLaXDzIbNQ,,/e02eeba3daf9b7357cdff80cf5a1e2f2/
 
Hi,


Again error message Please share the file.


The link you're trying to access can't be used to share files. Please ask the file owner to provide you with a shared link instead


Thanks,

Suresh Kumar S
 
1 last chance :(. please try below link and sorry for the interruption :(


https://www.box.com/s/bunzv39xlapgm4gkw1yx
 
Hi,


Paste the below formula on sheet2 B2 (change the last number (2) according to your output)


=INDEX(Sheet1!$A$1:$D$27,MATCH(Sheet2!A2,Sheet2!$A$1:$A$27,0),2)


Thanks,

Suresh Kumar S
 
Hi Ananthram ,


Try this :


=INDEX(TP_ID_s,SMALL(IF(Test_Type=A1,ROW(Test_Type)),COUNTIF(A$1:A1,A1)))


entered as an array formula , using CTRL SHIFT ENTER.


TP_ID_s is a named range , referring to =Sheet1!$A$2:$A$27


Test_Type is a named range , referring to =Sheet1!$D$2:$D$27


Narayan
 
You must log in or register to reply here.
Back
Top