LOOKUP text return text

[jamie.cutting]

Im using

=LOOKUP(B343,N343:N468,L343:L468)

to lookup the text in B343 within N343:N468 and return the respective
data in column L.

No joy just N/A#

So I tried

=LOOKUP(TEXT(B343,""),N343:N468,L343:L468)

Which gave the same pitifull result. How should I identify the text
type as using my "" probably doesnt refer to anything. The value in
row B is a combination of numbers and letters so I would think it is
just identified as a normal text string?

Any help would be much appreciated

Thanks

 

[Guest]

It's because your trying to do a left lookup it's going wrong. Try this
instead:-

=INDIRECT(ADDRESS(ROW(N343:N468)+MATCH(D343,N343:N468,0)-1,COLUMN(N343:N468)-2))

Mike

 

[Bernard Liengme]

Are the values in N arranged in ascending order?

Alternative to LOOKUP:
=INDEX(L343:L348,MATCH(B343,N343:N348,0))
best wishes

 

[Bernard Liengme]

A 'left lookup' works fine it everything else is OK

 

[Sebation.G]

try
=LOOKUP(,0/(N343:N468=B343),L343:L468)

 

[Guest]

I want to create workbook source file that has 6 workbooks involved. This
allows everyone to update their own workbook. From the client's last name
which will be constant in each workbook; I need to gather information in a
diffrent column, (which is text to text) to return results. Only one catch,
text may be seperated by comma's in one workbook and another may just have
text. What I want is to return a results when you type in a clients name on
the source file from all 6 workbooks.

Thanks