ExcelBanter - Why doesn't this work?

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Why doesn't this work? (https://www.excelbanter.com/charts-charting-excel/205-why-doesnt-work.html)

curtis_tx

Why doesn't this work?

=LOOKUP(Sheet2!A2:A10,"*"&C1&"*",Sheet2!B2:B10)
This resides in Sheet1, C1 is a cell that I type the search 'target' into,
so it changes as needed. I get a #VALUE! error.

Frank Kabel

Hi
use
=VLOOKUP("*"&C1&"*",'sheet2'!A2:B10,2,0)

--
Regards
Frank Kabel
Frankfurt, Germany

curtis_tx wrote:
=LOOKUP(Sheet2!A2:A10,"*"&C1&"*",Sheet2!B2:B10)
This resides in Sheet1, C1 is a cell that I type the search 'target'
into, so it changes as needed. I get a #VALUE! error.

All times are GMT +1. The time now is 11:15 PM.