web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... VLookups for Data Conv...

Small and medium business | Business Central, N...

Answered

VLookups for Data Conversion

(3) Share

Report

Report

Posted on by JE-20081519-0

3,549

Hi:

For data conversion using an Excel spreadsheet, utilizing the VLookup formula including ISERROR becomes useful.

I had a hard time working with such formulas today with one of the columns to be worked with had a mix of Text, General, and Number characters.

What are some ways of still getting great use out of VLookup when you have such a mix in one column?

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

KasparsSemjonovs 4,817 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

just define the whole column as text type.
But this should be posted on Excel forum, not SME :)

2 people found this reply helpful.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,946 Super User 2026 Season 1

#2

YUN ZHU 1,177 Super User 2026 Season 1

#3

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans