# VLOOKUP Formula ?

#### zone709

##### Well-known Member
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),"")

#### zone709

##### Well-known Member
I have to get back on the Vlookup here for now. Still stuck on other one.

On the Lookup =IFERROR(VLOOKUP(@\$D\$8:\$D\$694, Detailed_View!\$D\$2:\$P\$395,8,0),"") I need to add if column E also on the Detailed_view has the word Monday in it then return line ,8

This works now if D on both sheet match. Then is returns line line,8 but i need to add if also column E matches on detailed sheet the word Monday. Then return ,8

### Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

#### Fluff

##### MrExcel MVP, Moderator
Two things
1) the formula in post#10 id not the one I used in your previous thread.
2) Are you sure that you are using 2016 & not 365 as you would not get (or need) the @ sign in your formula in 2016.

#### zone709

##### Well-known Member
Sorry now i am confused. This post #10 ?

#### Fluff

##### MrExcel MVP, Moderator
Post#10 is the last post on the 1st page, each post has a number at the right hand side of the post

#### zone709

##### Well-known Member

ADVERTISEMENT

If i cant figure it out cause index match is a little hard for me because i kind of need to use it. Then ill have to add a small macro copying and pasting column D to column A then use the lookup function. Cause then i can start from A2 and work across to C to return instead of going backwards.

#### Fluff

##### MrExcel MVP, Moderator
If you look at your previous thread where you were concatenating to values, both of those values were extracted using an index match formula & that is what you need to use for this.

#### zone709

##### Well-known Member

ADVERTISEMENT

ok yes i am just going back now and understand what you are saying. I just need to take one of the columns out. The last post i am returning 2 columns cause its first and last name

#### zone709

##### Well-known Member
I think i am close?

=IFERROR(CONCATENATE(INDEX(Detailed_View!\$C\$2:\$C\$300,MATCH(D8,Detailed_View!\$D\$2:\$D\$302,0)),")

#### Fluff

##### MrExcel MVP, Moderator
That's it
Although you can get rid of the concatenate function & it's best to have the same sized ranges
Excel Formula:
``=INDEX(Detailed_View!\$C\$2:\$C\$300,MATCH(D8,Detailed_View!\$D\$2:\$D\$300,0))``

#### zone709

##### Well-known Member
That's it
Although you can get rid of the concatenate function & it's best to have the same sized ranges
Excel Formula:
``=INDEX(Detailed_View!\$C\$2:\$C\$300,MATCH(D8,Detailed_View!\$D\$2:\$D\$300,0))``
Boom works. It took me a little bit to understand all this but makes sense now. Now my last thing i need on that Lookup ? I need to add to look at Column E for the word Monday. Should i stay on this same thread?

Replies
20
Views
211
Replies
3
Views
105
Replies
11
Views
276
Replies
3
Views
49
Replies
10
Views
168

Threads
1,130,061
Messages
5,639,834
Members
417,117
Latest member
Ravi Pandey

### 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

### 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