Rock Robbster
New Member
- Joined
- Feb 18, 2004
- Messages
- 17
This is my first time using vlookup (if that's what I want to even do). My scenario is this: I have an Intake sheet where I take the customer's order down using Data Validation. I want whatever I choose to come up on a seperate sheet that is Invoice sheet. (i.e. choose from food 1, food 2, food 3 etc.-when say food 1 is selected, I have it come up on the Invoice sheet, now how do I have the price for food 1 come up with that?)
I was thinking of writing a like string such as if food 1 then $price 1 else etc etc. There is a lot of info that I take from customers on the intake, and the less looking up and typing I do the better. Any help would be greatly appreciated.
I was thinking of writing a like string such as if food 1 then $price 1 else etc etc. There is a lot of info that I take from customers on the intake, and the less looking up and typing I do the better. Any help would be greatly appreciated.