Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JerrySpringer
- Content: Threads
- Order by date
-
VLOOKUP with 2 LOOKUP VALUES???
Hi, Is it possible to do a vlookup with 2 lookup values? I have a list like such; abc 1 orange abc 2 Apple abc 3 Grape cde 1 Pear cde 2 Banana I need to look up the first value "ABC" then the second "2" and pull back apple. is this possible? Thank...- JerrySpringer
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Calculating data fields in a pivot table
OK, I had such good luck on my first post I decided to try another. I was working on this a few weeks ago and gave up. I have two data fields in a pivot table that are set to count. How would I divide one by the other in the pivot table? Am I making sense and is this possible? THank You, JS- JerrySpringer
- Thread
- Replies: 4
- Forum: Microsoft: Office
-
Invetory in EXCEL
I keep my invetory in EXCEL. In cell E21 I have current stock, in F21 I have monthly usage, and in G21 I have the following formula =ROUND(E21/F21,0)-1 which tells me how many months of product I have. What I would like in H21 is a formula that tells me the month that I will re-order. Anyone...- JerrySpringer
- Thread
- Replies: 2
- Forum: Microsoft: Office
