A few typos, Francis:

=VLOOKUP(A4,Sheet2!B2:C10,2,0)

and:

=IF(ISNA(VLOOKUP(A4,Sheet2!B2:B10,1,0)),"",VLOOKUP (A4,Sheet2!
B2:C10,2,0))

Hope this helps.

Pete

On Feb 24, 7:00*pm, xlmate wrote:
try this in B4

=VLOOKUP(A4,Sheet2!B2:B10,2,0)

to ignore ISNA when there is no match, use this
=IF(ISNA(VLOOKUP(A4,Sheet2!B2:B10,2,0)),"",VLOOKUP (A4,Sheet2!B2:B10,2,0))

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you. *

Thank You

cheers, francis



"KenCanuck" wrote:
I have 2 worksheets. I need to have a formula that reads cell (Ex.) A4 in
Sheet 1 then references Sheet 2 to match that text out of a list (B2-B10) and
supply the corresponding value in (C2-C10). *This result (the formula) will
be in cell B4 on sheet 1. *I thought it was a MATCH function but I can't get
it to work.

Thanks! - Ken- Hide quoted text -

- Show quoted text -

Hi Pete

Thanks.


--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"Pete_UK" wrote:

A few typos, Francis:

=VLOOKUP(A4,Sheet2!B2:C10,2,0)

and:

=IF(ISNA(VLOOKUP(A4,Sheet2!B2:B10,1,0)),"",VLOOKUP (A4,Sheet2!
B2:C10,2,0))

Hope this helps.

Pete

On Feb 24, 7:00 pm, xlmate wrote:
try this in B4

=VLOOKUP(A4,Sheet2!B2:B10,2,0)

to ignore ISNA when there is no match, use this
=IF(ISNA(VLOOKUP(A4,Sheet2!B2:B10,2,0)),"",VLOOKUP (A4,Sheet2!B2:B10,2,0))

--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.

Thank You

cheers, francis



"KenCanuck" wrote:
I have 2 worksheets. I need to have a formula that reads cell (Ex.) A4 in
Sheet 1 then references Sheet 2 to match that text out of a list (B2-B10) and
supply the corresponding value in (C2-C10). This result (the formula) will
be in cell B4 on sheet 1. I thought it was a MATCH function but I can't get
it to work.

Thanks! - Ken- Hide quoted text -

- Show quoted text -