Hi Guys,
This seems simple and I am pretty certain that it is - but I am stumped.
Please refer to attached.
- This is a simple price list estimator.
- There are 2 worksheets. (1 = work, that you work from) (2 = static
information/vlookup table)
I cannot figure out how to return values base
Are the qty min max consistent through out the table? If so, instead of
vlookup, you can use MATCH instead
I also have a multi-tiered pricing setup. I have written the table to have
mutli columns for the prices
Here is a sample of my lookup price table
ITEM DESCRIPTION QTY PRICE QTY PRICE QT
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Bill Q
Sent: Sunday, November 10, 2013 10:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup - Price List
Hi Guys,
This seems simple and I am pretty certain that it is - b
Hi Excel Guru's,
Need help
Please find the attached file
when i go into the location sheet and select the location, kindly help me
how to update.
Regards
Harish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of th
