look up text and return corresponding number

**doylzer** · 10-15-2014, 04:48 AM

hi All,

I have attached my example for ease of use.

I am trying create a formula so in G2:G6 i can search for the name in F2:F6 and if it matches a cell in B2:B6 that it will return the relevant cell in column C.

So for example Jo(F2) returns C3

Thanks.

**Pepe Le Mokko** · 10-15-2014, 04:50 AM

Perhaps try VLOOKUP or an INDEX/MATCH combination

**Fotis1991** · 10-15-2014, 04:53 AM

Hi

Try

Formula:

Please Login or Register  to view this content.

OR

Formula:

Please Login or Register  to view this content.

**samba_ravi** · 10-15-2014, 05:00 AM

=IFERROR(VLOOKUP(F2,$B$2:$C$6,2,0),"not matched")
can try this too

**Kamboj** · 10-15-2014, 05:08 AM

try this
=IFERROR(INDEX($B$2:$C$6,MATCH(F2,$B$2:$B$6,0),2),"Not Matched")

look up text and return corresponding number

LinkBack

Thread Tools

Rate This Thread

Display

look up text and return corresponding number

Re: look up text and return corresponding number

Re: look up text and return corresponding number

Re: look up text and return corresponding number

Re: look up text and return corresponding number

Thread Information

Users Browsing this Thread

Similar Threads

How to return the column number of the last text string in a row

[SOLVED] Return the first number in a text string

[SOLVED] Return row number of text string

deducting one text box value from another to return number of hours

[SOLVED] how do i use VLOOKUP to find text and return a number?

Bookmarks

Bookmarks

Posting Permissions