Vlookup for different columns in worksheet

[Haz]

Hi,

I have numbers in col A , which i would like to match in col E and if there
is a match i want it to return that exact number in col M. Would it then be
possible to return the values of that row Col F,G,H,I,J,K,L by copy across
this function?

Any help would be apprecaited.

Thanks
Haz

 

[Bernard Liengme]

I am not clear on the question. But have a look at INDEX and MATCH and come
back if more questions
best wishes

 

[Max]

I have numbers in col A, which i would like to match in col E
and if there is a match i want it to return that exact number in col M.

In M1: =IF(ISNUMBER(MATCH(A1,E:E,0)),A1,"")
Copy M1 down to the last row of data in col A

Would it then be possible to return the values of that row
Col F,G,H,I,J,K,L by copy across this function?

Sure. This will deliver it further based on col M
In N1: =IF($M1="","",INDEX(F:F,MATCH($A1,$E:$E,0)))
Copy N1 across to T1, fill down
This returns required results from cols F to L

---

 

[Haz]

Hi Max,
Thanks for getting back to me This works perfectly, However I forget to
mention that data in col A stops at A92 but the matching Col's E - F continue
down to row 209. As a result this fuction is not picking up everyone. Is it
possible to adjust this function or will i need a Vlookup now?

Many Thanks

Haz

 

[Max]

I'm not sure if its possible

Can you upload your sample file/data* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload your sample,
then paste the link into your reply here

 

[Haz]

this works perfectly, I have added a handful of entries by cut & paste so
need to adjust function here.

 

[Max]

glad you sorted it out over there