VLOOKUP Formula ?

[zone709]

Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried -1 but that doesn't work.

=IFERROR(VLOOKUP(@$D$8:$D$694, Detailed_View!$D$2:$P$395,1,0),"")

 

[mart37]

When the search column isn't the first column you can use INDEX and MATCH.

 

[zone709]

I use something like this now. I changed it to C which its puling the right column in but the countif needs to come out and maybe something else. Any help with this? When pulling this formula down it pulls in just one word. So its not working right.

=IFERROR(INDEX(Detailed_View!$C$2:$C$306,MATCH(0,INDEX(COUNTIF(D$7:D7,Detailed_View!$C$2:$C$306),0),0)),"")

 

[Fluff]

Use the index match the same way I did in your last thread.

 

[zone709]

Hi i just did after he mention it but i am getting the same return when i pull the formula down. I need d to match d on detailed sheet and return the column before which is C.

 

[zone709]

I also have one more question on the Lookup i use now. I should stay on this same thread right?

 

[Fluff]

Have you sorted this problem yet?

 

[zone709]

No i tried something else on the index formula and its not picking up column C

 

[Fluff]

What did you try?

 

[zone709]

Just took the countIf out but returns blank. I know i am not looking to repeat only one thing why i took it out.

=IFERROR(INDEX(Detailed_View!$C$2:$C$306,MATCH(0,INDEX((D$10:D$10,Detailed_View!$C$2:$C$306),0),0)),"")