Vlookup for different columns in worksheet
 

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

Vlookup for different columns in worksheet
 

I am not clear on the question. But have a look at INDEX and MATCH and come
back if more questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Haz" wrote in message
...
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

Vlookup for different columns in worksheet
 

"Haz" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Vlookup for different columns in worksheet
 

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" wrote:

"Haz" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Vlookup for different columns in worksheet
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Haz" wrote in message
...
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

Vlookup for different columns in worksheet
 

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

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Haz" wrote in message
...
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

Vlookup for different columns in worksheet
 

glad you sorted it out over there
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Haz" wrote in message
...
this works perfectly, I have added a handful of entries by cut & paste so
need to adjust function here.