THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

just wrote this formula

Jordan_229_2 [Edit] [Delete] 16:45, 25 February '15

=IFERROR(IF(VLOOKUP(E2,'List'!A:B,2,FALSE)="Red","140633-5000-000",IF(VLOOKUP(E2,'List'!A:B,2,FALSE)="Blue","140639-5000-000",(IF(E2="Green",("290010"&"-"&"5000"&(IFERROR(VLOOKUP(E2,'Form'!B:C,2,FALSE),"-000"))),(G2&"-"&E2&(IFERROR(VLOOKUP(E2,'Form'!B:C,2,FALSE),"-000"))))))),0)

worked first time.