Lookup

I am trying to do a lookup and failing miserable although have done them in
the past..

I have a spreadsheet with 2 columns of data ie

Column 1 Column 2
BS 873 BS en 123, BS EN 542

Column 1 is sorted in order.

I have done a lookup on another sheet to look at column 1 and give me column
2 but it only gives me a 'value'. The only way I can get it to work is if I
change column 2 to 123 but I need all the information in that cell.

Can anyone help

Leonard
Wed May 07 06:03:04 PDT 2008

People in a newsgroup for your spreadsheet program can help.

---
Leonard Grey
Errare humanum est

Elaine Munro wrote:
> I am trying to do a lookup and failing miserable although have done them in
> the past..
>
> I have a spreadsheet with 2 columns of data ie
>
> Column 1 Column 2
> BS 873 BS en 123, BS EN 542
>
> Column 1 is sorted in order.
>
> I have done a lookup on another sheet to look at column 1 and give me column
> 2 but it only gives me a 'value'. The only way I can get it to work is if I
> change column 2 to 123 but I need all the information in that cell.
>
> Can anyone help

Lee
Wed May 07 08:54:20 PDT 2008

Assuming MS Excel, the legacy function LOOKUP can only return a value. To
return any kind of data such as a string use VLOOKUP or HLOOKUP.

"Elaine Munro" <ElaineMunro@discussions.microsoft.com> wrote in message
news:1F6E5B71-6972-4FD1-A247-7CCA41C516E6@microsoft.com...
> I am trying to do a lookup and failing miserable although have done them
> in
> the past..
>
> I have a spreadsheet with 2 columns of data ie
>
> Column 1 Column 2
> BS 873 BS en 123, BS EN 542
>
> Column 1 is sorted in order.
>
> I have done a lookup on another sheet to look at column 1 and give me
> column
> 2 but it only gives me a 'value'. The only way I can get it to work is if
> I
> change column 2 to 123 but I need all the information in that cell.
>
> Can anyone help