VLOOKUP Help?

[MrSales]

I have a lot on information on 1 line and i want to find the information located to first cell to the right of the cell I'm looking for. i want green to be returned. I'm getting N/A returned

Example

A B C D E F G
Blue =VLOOKUP(A1,D1:G1,2,FALSE RED BLUE GREEN ORANGE

Thank you,

[Carim]

Hi,

Just encapsulate your vlookup() function in an offset() ...

Please Login or Register  to view this content.

HTH
Carim

[MrSales]

Thanks for the reply. It is saying that there is an error in the formula.

[Carim]

Hi,

Hopefully following formula will do the job ...

Please Login or Register  to view this content.

HTH
Carim

[MrSales]

Carim,

I really appreciate the help you are giving me but that didn't work either. How do I upload the file and then maybe you can review it for me in the event i'm not properly conveying what I'm trying to do?

[Carim]

Hi,

Best solution is to winzip your excel file,
then you attach the winziped file and upload it before sending it ...

HTH
Carim

[MrSales]

Carim,

I uploaded the copy and pasted only version because my file is too large even after it is zipped. Basically what I'm trying to accomplish the following:

I want J5= the information in the first column to the right of what is located in Z5:AF5 based on what is listed in E5.
I had used =VLOOKUP(E5,Z5:AF5,1,FALSE) which doesn't work.

Thank you so much for your help.

[Carim]

For the sake of clarification ...

when you say

"the information in the first column to the right of what is located in Z5:AF5"

I understand contents of cell AG5 which is empty ...
so I fell lost ...

What exactly should appear in cell J5 ? which word or value ?

Carim

[MrSales]

I want the information to read whatever is in the first column to the right of the selected column.

Example on Line 5. if E5 reads Roll thread i want J5-=cell AC being that roll thread is in AB.

Does this help?

[Carim]

YES ... it does ...

Formula is

Please Login or Register  to view this content.

HTH
Carim

[MrSales]

Carim,

I just wanted to thank you very much for the help!!!!!

[Carim]

Glad your problem 's fixed

Thanks for the feedback

Carim