using a formula to create an ordered purchase order

J

Jesse

I use excel to send out request for quotes to vendors and then transfer that
information into a purchase order. I send out a request for quote to several
vendors for the same products. When vendors return the request I open an
excel spreadsheet and put the prices in each vendors spreadsheet. I've
created a spreadsheet that allows me to put an "x" beside the cheapest price
and an excel formula coppies the description and the price to a different
purchase order spreadsheet. =IF('RFQ Results'!D8="X",'RFQ 1'!D18," ") The
problem arises when I purchase items from the same request for quote from
different vendors. The way the formula is written when I put an "x" beside
line items 1, 4, and 7 on the request for quote they are coppied to lines 1,
4, and 7 on the purchase order instead of lines 1, 2, and 3 on the purchase
order. I need a formula that allows me to select lines 1, 4, and 7 from the
request for quote page and places the itme in lines 1, 2, and 3 of a purchase
order sheet. Does anyone know how? Thanks
 
D

dan dungan

I would need more specific information, like:

Which spreadsheet holds this formula?
=IF('RFQ Results'!D8="X",'RFQ 1'!D18," ")


Show these specific formulas:
The way the formula is written when I put an "x" beside
line items 1, 4, and 7 on the request for quote they are coppied to
lines 1, 4, and 7 on the purchase order instead of lines 1, 2, and 3
on the purchase
order.
 
J

JLatham

May also want to ask how many items might need to be transferred in total.
Keep in mind the limit of 7 levels of nesting in a formula. If there's going
to be a need for more testing than that, it may be required to look to a VBA
solution.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top