=IFERROR(VLOOKUP($C16,A$6:B$47,2,FALSE),"") only picks some items

[oomfh]

The current column (G16 in my case) only enters a few numbers from column B when C matches A

 

[Aladin Akyurek]

The current column (G16 in my case) only enters a few numbers from column B when C matches A

What do you have in C16, A6:A47, and B6:B46? Numbers, text, dates, etc.

 

[oomfh]

C16 = employee name

A6:A47 = employee name

B6:B47 = number format

G16 = number format

 

[Aladin Akyurek]

C16 = employee name

A6:A47 = employee name

B6:B47 = number format

G16 = number format

I assume G16 is the cell with the first formula occurrence.

I also assume that you get #N/A while that's not expected.

What do we get with:

=LEN(C16)=LEN(TRIM(C16))

 

[oomfh]

Aladin,

Deadlines rest of this week . . . back to this next week

thx

 

[oomfh]

I assume G16 is the cell with the first formula occurrence.

Current column is G, G6 is the first formula occrence. Column D through J contain the forumula.

I also assume that you get #N/A while that's not expected.

My formula would result in #N/A except I have "" for FALSE

What do we get with: =LEN(C16)=LEN(TRIM(C16))

I get all "TRUE" even when there result should clearly be "FALSE"

 

[Aladin Akyurek]

Current column is G, G6 is the first formula occrence. Column D through J contain the forumula.

I also assume that you get #N/A while that's not expected.

My formula would result in #N/A except I have "" for FALSE

What do we get with: =LEN(C16)=LEN(TRIM(C16))

I get all "TRUE" even when there result should clearly be "FALSE"

Does...

=IFERROR(VLOOKUP(TRIM($C16),A$6:B$47,2,FALSE),"")

yield what you expect to get?

 

[oomfh]

Does...

=IFERROR(VLOOKUP(TRIM($C16),A$6:B$47,2,FALSE),"")

yield what you expect to get?

Using your latest formula - it still gives correct results - but only randomly . . .

Column C and A contain the employee names - "Last name, First name"

As a test I deleted the first names and comma - leaving only "Last name" This gives the desired results consistently.

"Last name, first name" in column C and A are downloads. Is there a way for Excel recognize/relate these? Both columns are currently Text formats.

 

[Aladin Akyurek]

Using your latest formula - it still gives correct results - but only randomly . . .

Column C and A contain the employee names - "Last name, First name"

As a test I deleted the first names and comma - leaving only "Last name" This gives the desired results consistently.

"Last name, first name" in column C and A are downloads. Is there a way for Excel recognize/relate these? Both columns are currently Text formats.

Would you please post a small sample along with a look up value and the expected outcome?

P.S. Please try not to use fully colored text.

 

[oomfh]

Would you please post a small sample along with a look up value and the expected outcome?

I have searched for instructions to post only a portion of a spreadsheet. I'm having difficulties converting the selection to JPEG.

?