VLOOKUP to add new data to a template
Hi There,
I need to create a VLOOKUP which pulls data from a main list into a template which I will print.
I want to pull the Part Number (column A) from the sheet labelled 'MAIN LIST' into the column A in sheet labelled 'PRICE LIST' where column C in sheet 'MAIN LIST' is equal to = CONTRACTOR LIST
I will continuously be adding new data to the main list, so the template will need to keep updating.
Thank you in advance.
Chloe
In A3 and copy down, this Array(control+shift+enter-not just enter) formula.
=INDEX('Main List'!$A2:$A1000,SMALL(IF('Main List'!$C$2:$C$1000="CONTRACTOR LIST",ROW('Main List'!$A2:$A1000)-1),ROW('Main List'!$A$1)))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you for your reply, I have tried this but it is bringing in some MAIN list parts? Not just contractor?
Thanks, Chloe
ApologIze for this. I forgot to use absolute reference..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks