FIND COLUMN DATA

[Dave]

Hi,

I need to find corresponding references in a sheet and then return the name
next to the reference. How do i do this?

Thanks

 

[Mike H]

Hi,

It could be VLOOKUP or it could be INDEX Match. You would need to be more
specific.

Mike

 

[Luke M]

Take a look at the LOOKUP and VLOOKUP functions in XL help, I believe one of
those is what you are looking for.

 

[Dave]

Hi

I have one sheet with a reference number. I need to find that reference
number in the other sheet and then return what name is next to that reference
numberin the column next to it.

Thanks

 

[Dave]

Yes. Its lookup. doh! Thanks for your help!

Take a look at the LOOKUP and VLOOKUP functions in XL help, I believe one of
those is what you are looking for.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

 

[Dave]

Hi

I thought I had it by using LOOKUP but this doesnt work!!! Any suggestions??

Thanks

 

[Dave]

Hi Mike

I thought I had this covered but it has not worked. I tried LOOKUP but it
just returned random names.

Thanks

 

[RagDyeR]

Sheet1 has your list of reference numbers, from A2 to A100.

Sheet2 has the datalist, with the numbers in say D1 to D75.

NOW, if the names are in a column to the *right* of the numbers, say E1 to
E75, you could use the Vlookup() function.

Enter this on Sheet1, in B2:

=Vlookup(A2,Sheet2!D$1:E$75,2,0)

And copy down.

If, on the other hand, the names in the datalist on Sheet are to the *left*
of the numbers, say C1 to C75, then use the Index() Match() combination in
B2 of Sheet1:

=Index(Sheet2!C$1:C$75,Match(A2,Sheet2!D$1$75,0))

And copy down.

You could of course use the Index/Match combo in the first case also, but
now you have exposure to different approaches.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

..
Hi Mike

I thought I had this covered but it has not worked. I tried LOOKUP but it
just returned random names.

Thanks

 

[Dave Peterson]

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

If this doesn't help, you're going to have to provide some details.

What value is being matched?

Where is the column that should be matched? Where is the column that should be
returned?