Vlookup or is there a better way

[Kurt]

Hello All,

In cell T10 I have a number let's say 334.

In cells U10 through AA 10 I have 334 834 394 884 839 389 889

I want to grab this info in cell M2.

Would Match or something else also do this trick?

Is there a better way to do this?

Again thanks in advance.

 

[wigi]

What should be the result of the formula, I do not understand what you need?

 

[Kurt]

Post the results in cell M10 going down.

There is a long list of lines of numbers like these.

 

[wigi]

Post the results in cell M10 going down.

WHAT result?

 

[Kurt]

The numbers in U10 through AA10

 

[wigi]

Sorry, but if you ain't gonna be more clear than this, I cannot be of any help.

Success with your question, I hope someone else can understand it.

 

[Kurt]

I want to grab the info in the lookup table in cells U10 through AA10 and post the entire results in cell M10 through S:10

Hope this helps

 

[wigi]

Apologies but this is Chinese to me.

You can copy the cells U10:AA10 to M10:S10.

I cannot say more sensible things about it since I have no clue what you're doing.

Show your sheet using the HTML maker, for instance.

 

[shawnhet]

Maybe this is too easy, but the way you've phrased it here you could simply set M10 as =U10, N10=V10 and so on up to S10. Otherwise, I agree with wigi that your post is very cryptic.

Cheers,

 

[Jaymond Flurrie]

Didn't really understand the question either, but I think that using Index and Match together is always better than using Lookups. I haven't ran so far into a lookup that Index and Match wouldn't solve.