Need advice on Lookup function

[scott-atkinson]

Can any of you guys give me assistance with a problem that I have.

I use Vlookup function regularly but need to know how to do the following.

I have a static report that I cannot change and I need to extract data from it using a Vlookup or similar function.

Below is a representaion of how this report is laid out.

Column A, Column B, Column C, Column D, Column E

I need to be able to reference a cell in Column E, but to return value in Column A, through D.

The easiest thing to do would be to swap column E data with Column A, but I do not have that luxury, I cannot change any aspect of this report.

Any help on achieving my this would be fantastic.

Please helpppppp

 

[unmarkedhelicopter]

try index and match

 

[scott-atkinson]

try index and match

Could you recommend a formula style for me, for example how would i build it to achieve what I want?

 

[Brianwarnock]

e.g
=INDEX(A: D,MATCH("lookupvalue",E:E),1)

will find ColA

Brian

There should be no space before the D but I got a smiley

 

[Brianwarnock]

Just realised from your post that you might want all 4 cols returned if so enter

=INDEX(A,MATCH("lookup value",E:E),0) into a cell and drag across 4 cells press F2 then Cntrl alt enter to enter as an array formula

Brian

 

[scott-atkinson]

Just realised from your post that you might want all 4 cols returned if so enter

=INDEX(A,MATCH("lookup value",E:E),0) into a cell and drag across 4 cells press F2 then Cntrl alt enter to enter as an array formula

Brian

Thanks Brian, that will be really useful.

 

[Brianwarnock]

Thanks Brian, that will be really useful.

=INDEX(A,MATCH("lookup value",E:E),0) into a cell and drag across 4 cells press F2 then Cntrl alt enter to enter as an array formula

Just discovered how to disable smileys.

Brian