VLOOKUP Formula ?

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
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),"")
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

mart37

Well-known Member
Joined
Aug 4, 2017
Messages
1,070
Office Version
  1. 2016
Platform
  1. Windows
When the search column isn't the first column you can use INDEX and MATCH.
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
Use the index match the same way I did in your last thread.
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

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

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
I also have one more question on the Lookup i use now. I should stay on this same thread right?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

Have you sorted this problem yet?
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
No i tried something else on the index formula and its not picking up column C
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
55,682
Office Version
  1. 365
Platform
  1. Windows
What did you try?
 

zone709

Well-known Member
Joined
Mar 1, 2016
Messages
1,976
Office Version
  1. 365
Platform
  1. Windows
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)),"")
 

Watch MrExcel Video

Forum statistics

Threads
1,127,880
Messages
5,627,443
Members
416,248
Latest member
inese_green

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top