Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

vlookup Formula required for Matching two column

0

Dear sir,

i am doing reconciliation of purchase invoice data with my online data for that i need a formula where both invoice in online and purchase register should match.

I have applied for vlookup formula but for some invoices its not matching.

For example in sheet1 invoice no as per purchase register is KMSS/034/22-23 BUT as per my purchase register is KMSS/34/22-23 how to match in this case.

as i have 10000 rows many vendors have many type of different numbers.

Please provide a formula to resolve the issue.

excel
posted by: rakeshb93 on Sat Jul 22, 2023 at 5:39 am
Answer
Discuss

Discussion

Hi Rakesh and welcome to the Forum. 

I'm not why your invoice and purchase register don't match. VLookup supports wildcards (so the sample two numbers could be matched) but how varied are the other "matching" entries? Please edit your original question and use the Add Files button to attach a representative Excel file (no personak data, about 30 rows perhaps).

If you don't respond I'll just sssume you cross-posted on several sites and have an answer already
John_Ru (rep: 6142) Jul 22, '23 at 6:42 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login