Hi

I am trying to create an 'Invoice' template using Vlookup with Data from Two worksheets- 'Item' where my product details are stored and 'ClientList' where my customer details are stored. My customer list is working fine, but when it comes to my 'Item', I am getting error messages (#N/A)

My Item list is as below and my Lookup column is Description(Data validation) and I wanted to get the Item code and the Price listed

My Vlookup formulas are as below

=VLOOKUP(C13,Item!$B$4:$E$16,1)

=VLOOKUP(C13,Item!$B$4:$E$16,3)

Item Code Description Price

LeReve-001 Dispensers 50
LeReve-002 Rough 20
LeReve-003 Flair 20
LeReve-004 Cheer 20
LeReve-005 Zeal 20
LeReve-006 Sooth 20
LeReve-007 Glow 20
LeReve-008 Zing 20
LeReve-009 Charm 20
LeReve-010 Crush 20
LeReve-011 Punch 20
LeReve-012 Bloom 20
LeReve-013 Spa 20

Can someone please help?

Thanks