Looking up Text and Numeric Entries

[copyboy007]

I'm seeking a formula that can look up both numeric and alphanumeric entries to find dates of matching invoices listed in another worksheet that has same invoice entries. But, the numeric invoice entries are in text format causing the lookup formula to give a #VALUE error for either of these formulas:

This works for alphanumeric entries, but not with numeric entries:
=VLOOKUP(I51768,'Entry Date vs Invoice Date'!C$1:G66000,5,FALSE)

This works with numeric entries, but not with alphanumeric entries:
=VLOOKUP(VALUE(I51768),'Entry Date vs Invoice Date'!C$1:G66000,5,FALSE)

Any advice?

 

[Joe4]

I find it is usually easier to fix the data, with a simple "Text to Columns" on the matching column, to make them all the same type.

 

[copyboy007]

I find it is usually easier to fix the data, with a simple "Text to Columns" on the matching column, to make them all the same type.

Can you clarify further, please?

 

[Joe4]

If you want them to all be text, select your column, then go to Data menu, and select "Text to Columns" on the "Data Tools" ribbon.
Hit next twice to get to step 3, then choose the Text option and click finish.
Now, every entry in that column will be "Text" and not "Number".

 

[copyboy007]

If you want them to all be text, select your column, then go to Data menu, and select "Text to Columns" on the "Data Tools" ribbon.
Hit next twice to get to step 3, then choose the Text option and click finish.
Now, every entry in that column will be "Text" and not "Number".

Appreciate the extra clarification. Works now. Thank you!

 

[Joe4]

You are welcome!