Member Avatar for bobbyraw

i have a database with names and id number. i also create an input sheet for sales. then i creat an invoice. here is what i need help with. when i put in any data on the input sheet i want it to be populated on the invoice. so on the input sheet i have animal name, animal id, animal price and amount of animal pruchase.

let say i want to sell animal ID #8 when i put the ID in, i want that aminal name and ID to show up on the invoice

so far i have used Vlookup but not able to get the information to change on the invoice when the input is changed on the input sheet.

can anyone help with this

Much appreciated

  • 3 Contributors
  • 2 Replies
  • 92 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Notiz Me
Member Avatar for cguan_77

can upload an excel file with dummy data on it?

Member Avatar for Notiz Me

The only thing I could think of is that you've forgotten to use the VALUE() function. An inpu-box generates text, you have to convert the text to a value before you can look is up with vlookup.

If that wasn 't the problem, post an example worksheet.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.